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 4962: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,

4958: CURSOR get_internal_party_csr IS
4959: SELECT internal_party_id from csi_install_parameters;
4960:
4961: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
4962: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
4963: OE_ORDER_HEADERS_ALL OE,
4964: oe_order_lines_all OEL
4965: WHERE OEL.line_id = p_oe_line_id AND
4966: OE.HEADER_ID = OEL.HEADER_ID AND

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

5738: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
5739: NVL(ACTIVE_END_DATE, SYSDATE + 1) >= SYSDATE;
5740:
5741: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5742: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5743: OE_ORDER_HEADERS_ALL OE,
5744: oe_order_lines_all OEL
5745: WHERE OEL.line_id = p_oe_line_id AND
5746: OE.HEADER_ID = OEL.HEADER_ID AND