[Home] [Help]
View: 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
Name |
ORGANIZATION_ID |
LOCATION_ID |
RECEIPT_NUM |
SHIPMENT_HEADER_ID |
RECOVERABLE_AMOUNT |
RECOVERED_AMOUNT |
CNT_INVOICE_NO |
CNT_INVOICE_DATE |
CNT_VENDOR_ID |
CNT_VENDOR_SITE_ID |
TOTAL_LINES |
LINES_WO_VAT_DETAILS |