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.CSC_SERVICE_KEY_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 84: FROM oe_order_headers_all oe, hz_cust_accounts hza

80:
81: -- Order Number
82: CURSOR order_num_cur IS
83: SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
84: FROM oe_order_headers_all oe, hz_cust_accounts hza
85: WHERE oe.sold_to_org_id = hza.cust_account_id AND
86: oe.order_number = l_skey_value;
87:
88: CURSOR order_contact_cur IS

Line 104: FROM oe_order_headers_all oe, hz_cust_accounts hza

100:
101: -- RMA Number
102: CURSOR rma_num_cur IS
103: SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
104: FROM oe_order_headers_all oe, hz_cust_accounts hza
105: WHERE oe.sold_to_org_id = hza.cust_account_id AND
106: -- Bug Fix 5136678 Added 'Mixed' Category Code
107: oe.order_category_code IN ('RETURN','MIXED') AND
108: oe.order_number = l_skey_value;