View: JAI_BOE_MATCHINGS_V

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

View Text

SELECT JRH.RECEIPT_NUM RECEIPT_NUM
, JRH.SHIPMENT_NUM SHIPMENT_NUM
, JRH.SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, JBM.BOE_ID
, SUM(JMT.TAX_AMOUNT) APPLIED_AMOUNT
FROM JAI_CMN_BOE_MATCHINGS JBM
, JAI_BOE_MATCHING_TAXES JMT
, JAI_RCV_HEADERS JRH
WHERE JBM.SHIPMENT_HEADER_ID = JRH.SHIPMENT_HEADER_ID
AND JBM.BOE_MATCHING_ID = JMT.MATCH_ID GROUP BY JBM.BOE_ID
, JRH.RECEIPT_NUM
, JRH.SHIPMENT_NUM
, JRH.SHIPMENT_HEADER_ID

Columns