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.

APPS.AHL_OSP_SHIPMENT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 5007: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,

5003: CURSOR get_internal_party_csr IS
5004: SELECT internal_party_id from csi_install_parameters;
5005:
5006: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5007: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5008: OE_ORDER_HEADERS_ALL OE,
5009: oe_order_lines_all OEL
5010: WHERE OEL.line_id = p_oe_line_id AND
5011: OE.HEADER_ID = OEL.HEADER_ID AND

Line 5787: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,

5783: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
5784: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;
5785:
5786: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5787: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5788: OE_ORDER_HEADERS_ALL OE,
5789: oe_order_lines_all OEL
5790: WHERE OEL.line_id = p_oe_line_id AND
5791: OE.HEADER_ID = OEL.HEADER_ID AND