View: JAI_RCV_RGM_TXNS_V

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

View Text

SELECT B.ORGANIZATION_ID
, B.LOCATION_ID
, B.SHIPMENT_HEADER_ID
, B.SHIPMENT_LINE_ID
, B.RCV_RGM_LINE_ID
, B.RECEIPT_NUM
, B.INVOICE_NO
, B.INVOICE_DATE
, B.INVENTORY_ITEM_ID
, B.BATCH_NUM
, B.PROCESS_STATUS_FLAG
, A.SCHEDULED_DATE
, A.INSTALLMENT_NO
, A.TAX_TYPE
, MIN(A.TRANSACTION_ID) TRANSACTION_ID
, SUM(A.INSTALLMENT_AMOUNT) INSTALLMENT_AMOUNT
FROM JAI_RCV_RGM_CLAIMS A
, JAI_RCV_RGM_LINES B
WHERE A.RCV_RGM_LINE_ID = B.RCV_RGM_LINE_ID
AND A.STATUS IN('N') GROUP BY B.ORGANIZATION_ID
, B.LOCATION_ID
, B.SHIPMENT_HEADER_ID
, B.SHIPMENT_LINE_ID
, B.RCV_RGM_LINE_ID
, B.RECEIPT_NUM
, B.INVOICE_NO
, B.INVOICE_DATE
, B.INVENTORY_ITEM_ID
, B.BATCH_NUM
, B.PROCESS_STATUS_FLAG
, A.SCHEDULED_DATE
, A.INSTALLMENT_NO
, A.TAX_TYPE

Columns