APPS.CSC_SERVICE_KEY_PVT dependencies on HZ_CUST_ACCOUNTS

Line 62: FROM hz_cust_accounts cust_acct, ra_customer_trx_all ra

58:
59: -- Invoice Number
60: CURSOR invoice_num_cur IS
61: SELECT cust_acct.party_id, cust_acct.cust_account_id, customer_trx_id, ra.org_id org_id
62: FROM hz_cust_accounts cust_acct, ra_customer_trx_all ra
63: WHERE cust_acct.cust_account_id = ra.bill_to_customer_id AND
64: ra.complete_flag = 'Y' AND
65: ra.cust_trx_type_id IN
66: ( SELECT cust_trx_type_id FROM ra_cust_trx_types_all

Line 73: FROM hz_cust_accounts cust_acct, ra_customer_trx ra

69:
70: -- Invoice Number -- MOAC
71: CURSOR invoice_num_moac_cur IS
72: SELECT cust_acct.party_id, cust_acct.cust_account_id, customer_trx_id, ra.org_id org_id
73: FROM hz_cust_accounts cust_acct, ra_customer_trx ra
74: WHERE cust_acct.cust_account_id = ra.bill_to_customer_id AND
75: ra.complete_flag = 'Y' AND
76: ra.cust_trx_type_id IN
77: ( SELECT cust_trx_type_id FROM ra_cust_trx_types

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;

Line 128: FROM csi_systems_vl csb, hz_cust_accounts hca

124:
125: -- System
126: CURSOR system_cur IS
127: SELECT hca.party_id, hca.cust_account_id, csb.system_id
128: FROM csi_systems_vl csb, hz_cust_accounts hca
129: WHERE csb.customer_id = hca.cust_account_id
130: AND csb.name = l_skey_value;
131:
132: -- Tag Number