APPS.CSC_SERVICE_KEY_PVT dependencies on OE_ORDER_HEADERS

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 97: FROM oe_order_headers oe, hz_cust_accounts hza

93:
94: -- Order Number -- MOAC
95: CURSOR order_num_moac_cur IS
96: SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
97: FROM oe_order_headers oe, hz_cust_accounts hza
98: WHERE oe.sold_to_org_id = hza.cust_account_id AND
99: oe.order_number = l_skey_value;
100:
101: -- RMA Number

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;

Line 113: FROM oe_order_headers oe, hz_cust_accounts hza

109:
110: -- RMA Number MOAC
111: CURSOR rma_num_moac_cur IS
112: SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
113: FROM oe_order_headers oe, hz_cust_accounts hza
114: WHERE oe.sold_to_org_id = hza.cust_account_id AND
115: --Bug Fix 5136678 Added 'Mixed' Category Code
116: oe.order_category_code IN ('RETURN','MIXED') AND
117: oe.order_number = l_skey_value;