View: JAI_CMN_BOE_APPLIED_V

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

View Text

SELECT JRB.TRANSACTION_ID TRANSACTION_ID
, JRB.SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, JBH.VENDOR_ID VENDOR_ID
, JBH.VENDOR_SITE_ID VENDOR_SITE_ID
, JBA.AGENT_NAME AGENT_NAME
, JRB.BOE_ID BOE_ID
, JRB.AMOUNT AMOUNT
FROM JAI_CMN_BOE_MATCHINGS JRB
, JAI_CMN_BOE_HDRS JBH
, JAI_CMN_BOE_AGENTS JBA
WHERE JRB.BOE_ID = JBH.BOE_ID
AND JBH.AGENT_ID = JBA.AGENT_ID

Columns