eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JAI_CMN_BOE_APPLIED_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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