[Home] [Help]
View: POR_INVOICES_SUMMARY_V
View Text
SELECT PRL.REQUISITION_LINE_ID
, PRL.LINE_LOCATION_ID
, PLC.DISPLAYED_FIELD
, RSH.INVOICE_NUM
, RSH.INVOICE_DATE
, TO_CHAR(RSH.INVOICE_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SOB.CURRENCY_CODE
, 30))
FROM PO_REQUISITION_LINES PRL
, PO_LINE_LOCATIONS PLL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_LOOKUP_CODES PLC
, GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND PLL.LINE_LOCATION_ID = RSL.PO_LINE_LOCATION_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND PLC.LOOKUP_CODE = DECODE(RSH.INVOICE_NUM
, NULL
, 'N'
, 'Y')
AND PLC.LOOKUP_TYPE = 'YES/NO'
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
Columns
Name |
REQUISITION_LINE_ID |
LINE_LOCATION_ID |
INVOICED_FLAG |
INVOICE_NUMBER |
INVOICE_DATE |
PAID_AMOUNT |