View: JAI_RCV_RGM_HEADERS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RCV_RGM_HEADERS_V

View Text

SELECT ORGANIZATION_ID
, LOCATION_ID
, RECEIPT_NUM
, SHIPMENT_HEADER_ID
, NVL(SUM(RECOVERABLE_AMOUNT)
, 0) RECOVERABLE_AMOUNT
, NVL(SUM(RECOVERED_AMOUNT)
, 0) RECOVERED_AMOUNT
, COUNT(DISTINCT INVOICE_NO) CNT_INVOICE_NO
, COUNT(DISTINCT INVOICE_DATE) CNT_INVOICE_DATE
, COUNT(DISTINCT VENDOR_ID) CNT_VENDOR_ID
, COUNT(DISTINCT VENDOR_SITE_ID) CNT_VENDOR_SITE_ID
, COUNT(*) TOTAL_LINES
, SUM(DECODE(INVOICE_NO
, NULL
, 1
, 0)) LINES_WO_VAT_DETAILS
FROM JAI_RCV_RGM_LINES GROUP BY ORGANIZATION_ID
, LOCATION_ID
, RECEIPT_NUM
, SHIPMENT_HEADER_ID

Columns