POR_REQUISITION_LINES_ALL Holds the Requisition line details. This post talks about Table structure, index and constraint details.
Category: Oracle Fusion Finance
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
Purchase Order Detail Query in Fusion
query to fetch the Purchase Order Details like shipment number, receipt number, buyer, Variance Default Account, Accrual Default Account, Inventory Expense Account, shipped quantity etc