VIEW: APPS.POR_INVOICES_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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