[Home] [Help]
View: 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
Name |
TRANSACTION_ID |
SHIPMENT_LINE_ID |
VENDOR_ID |
VENDOR_SITE_ID |
AGENT_NAME |
BOE_ID |
AMOUNT |