Query to fetch the value set details such as Value Set Name, Value, Description and associated tables in Oracle.
Tag: Oracle Training
DOO_FULFILL_LINES_ALL: Columns, Indexes & Imp Points
doo_fulfill_lines_all: column, index and constraint details : the table which holds the fulfilment details of Sales Order Line
Journal Reconciliation Query in Oracle Fusion
Query to reconcile the journals in Oracle Fusion to match the books against certain GL accounts.
Vendor Fiscal Classification Query in Oracle Fusion
Query to to get the vendor fiscal classification code in Oracle Fusion Finance.
Item Detail Query in Oracle Fusion Finance
query to fetch the Item Details in Oracle Fusion Finance like Planner, Lead Time, status, minimum Order quantity, Unit Length, lot multiplier etc