Product: | FV - Federal Financials |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AI.SET_OF_BOOKS_ID
, GSB.NAME
, AI.INVOICE_NUM
, AI.INVOICE_DATE
, AID.AMOUNT
, '_KF:SQLGL:GL#:GCC'
, PH.SEGMENT1
, PD.GL_ENCUMBERED_DATE
, (NVL(PD.QUANTITY_ORDERED
, 0) - NVL(PD.QUANTITY_CANCELLED
, 0))*NVL(PL.UNIT_PRICE
, 0)
, PL.CLOSED_CODE
, PRH.SEGMENT1
, PRD.GL_ENCUMBERED_DATE
, (NVL(PRL.QUANTITY
, 0) - NVL(PRL.QUANTITY_CANCELLED
, 0))*NVL(PRL.UNIT_PRICE
, 0)
FROM AP_INVOICES AI
, AP_INVOICE_DISTRIBUTIONS AID
, GL_CODE_COMBINATIONS GCC
, GL_SETS_OF_BOOKS GSB
, PO_DISTRIBUTIONS PD
, PO_LINE_LOCATIONS PLL
, PO_LINES PL
, PO_HEADERS PH
, PO_REQ_DISTRIBUTIONS PRD
, PO_REQUISITION_LINES PRL
, PO_REQUISITION_HEADERS PRH
WHERE AI.INVOICE_ID = AID.INVOICE_ID
AND AI.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND GSB.SET_OF_BOOKS_ID = AID.SET_OF_BOOKS_ID
AND GCC.CODE_COMBINATION_ID = AID.DIST_CODE_COMBINATION_ID
AND PD.PO_DISTRIBUTION_ID (+) = AID.PO_DISTRIBUTION_ID
AND PD.SET_OF_BOOKS_ID (+) = AID.SET_OF_BOOKS_ID
AND PLL.LINE_LOCATION_ID (+) = PD.LINE_LOCATION_ID
AND PL.PO_LINE_ID (+) = PLL.PO_LINE_ID
AND PH.PO_HEADER_ID (+) = PL.PO_HEADER_ID
AND PRD.DISTRIBUTION_ID (+) = PD.REQ_DISTRIBUTION_ID
AND PRL.REQUISITION_LINE_ID (+) = PRD.REQUISITION_LINE_ID
AND PRH.REQUISITION_HEADER_ID (+) = PRL.REQUISITION_HEADER_ID WITH READ ONLY