Query to fetch the price, price list and charges of an item and the tables behind it in Oracle Fusion. Also the usage of various tables.
Tag: Oracle Training
RTF Date Formatting With Example
How to insert the date in various formats in RTF template for XML or BI Publisher Report along with Syntax and Corresponding output.
Reserved Quantity & Available Quantity Query in Fusion
How to Query the Reserved & Available Quantity in Oracle Fusion
POR_REQUISITION_HEADERS_ALL: Columns & Indexes
POR_REQUISITION_HEADERS_ALL: Column Details, index and constraints.
POR_REQUISITION_LINES_ALL: Columns & Index
POR_REQUISITION_LINES_ALL Holds the Requisition line details. This post talks about Table structure, index and constraint details.