VIEW: APPS.JAI_RCV_RGM_TXNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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