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.CSL_CSP_LOCATIONS_ACC_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 10: -- HZ_CUST_ACCT_SITES_ALL

6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_CSP_RS_CUST_RELATIONS_ACC';
7: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_RS_CUST_RELATIONS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RS_CUST_RELATION_ID';
10: -- HZ_CUST_ACCT_SITES_ALL
11: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_ACCT_SITES_ALL_ACC';
12: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
13: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CUST_ACCT_SITES');
14: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CUST_ACCT_SITE_ID';

Line 11: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_ACCT_SITES_ALL_ACC';

7: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_RS_CUST_RELATIONS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RS_CUST_RELATION_ID';
10: -- HZ_CUST_ACCT_SITES_ALL
11: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_ACCT_SITES_ALL_ACC';
12: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
13: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CUST_ACCT_SITES');
14: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CUST_ACCT_SITE_ID';
15: -- HZ_CUST_SITE_USES_ALL

Line 41: , HZ_CUST_ACCT_SITES_ALL CAS

37: , CSU.status STATUS
38: , RCR.resource_id RESOURCE_ID
39: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
40: , HZ_CUST_SITE_USES_ALL CSU
41: , HZ_CUST_ACCT_SITES_ALL CAS
42: , CSP_RS_CUST_RELATIONS RCR
43: , HZ_PARTY_SITES HPS
44: , HZ_LOCATIONS HZL
45: WHERE PLA.location_id = b_location_id

Line 127: , HZ_CUST_ACCT_SITES_ALL CAS

123: , HPS.party_site_id HPS_ID
124: , RCR.RESOURCE_ID RESOURCE_ID
125: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
126: , HZ_CUST_SITE_USES_ALL CSU
127: , HZ_CUST_ACCT_SITES_ALL CAS
128: , CSP_RS_CUST_RELATIONS RCR
129: , HZ_PARTY_SITES HPS
130: WHERE PLA.location_id = b_location_id
131: AND CSU.site_use_id = PLA.site_use_id

Line 180: -- HZ_CUST_ACCT_SITES_ALL

176: , P_PK1_NAME => g_pk1_name1
177: , P_PK1_NUM_VALUE => r_location_ids.RCR_ID
178: , P_RESOURCE_ID => l_resource_id
179: );
180: -- HZ_CUST_ACCT_SITES_ALL
181: JTM_HOOK_UTIL_PKG.Insert_Acc
182: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
183: , P_ACC_TABLE_NAME => g_acc_table_name2
184: , P_PK1_NAME => g_pk1_name2

Line 233: , HZ_CUST_ACCT_SITES_ALL CAS

229: , HZL.location_id HZL_ID
230: , RCR.resource_id RESOURCE_ID
231: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
232: , HZ_CUST_SITE_USES_ALL CSU
233: , HZ_CUST_ACCT_SITES_ALL CAS
234: , CSP_RS_CUST_RELATIONS RCR
235: , HZ_PARTY_SITES HPS
236: , HZ_LOCATIONS HZL
237: WHERE PLA.location_id = b_location_id

Line 299: -- HZ_CUST_ACCT_SITES_ALL

295: ,g_acc_table_name1
296: ,l_resource_id
297: ,l_rcr_acc_id
298: );
299: -- HZ_CUST_ACCT_SITES_ALL
300: l_cas_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id(
301: P_ACC_TABLE_NAME => g_acc_table_name2
302: , P_PK1_NAME => g_pk1_name2
303: , P_PK1_NUM_VALUE => r_location_ids.CAS_ID

Line 367: , HZ_CUST_ACCT_SITES_ALL CAS

363: , HPS.party_site_id HPS_ID
364: , RCR.RESOURCE_ID RESOURCE_ID
365: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
366: , HZ_CUST_SITE_USES_ALL CSU
367: , HZ_CUST_ACCT_SITES_ALL CAS
368: , CSP_RS_CUST_RELATIONS RCR
369: , HZ_PARTY_SITES HPS
370: WHERE PLA.location_id = b_location_id
371: AND CSU.site_use_id = PLA.site_use_id

Line 428: , 'Delete HZ_CUST_ACCT_SITES_ALL acc record for user: ' || p_resource_id

424: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
425: jtm_message_log_pkg.Log_Msg
426: ( p_resource_id
427: , g_table_name
428: , 'Delete HZ_CUST_ACCT_SITES_ALL acc record for user: ' || p_resource_id
429: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
430: END IF;
431: JTM_HOOK_UTIL_PKG.Delete_Acc
432: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2

Line 659: , HZ_CUST_ACCT_SITES_ALL CAS

655: CURSOR c_location( b_resource_id NUMBER ) IS
656: SELECT PLA.LOCATION_ID
657: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
658: , HZ_CUST_SITE_USES_ALL CSU
659: , HZ_CUST_ACCT_SITES_ALL CAS
660: , CSP_RS_CUST_RELATIONS RCR
661: , HZ_PARTY_SITES HPS
662: WHERE CSU.site_use_id = PLA.site_use_id
663: AND CSU.site_use_code = 'SHIP_TO'

Line 709: , HZ_CUST_ACCT_SITES_ALL CAS

705: CURSOR c_location( b_resource_id NUMBER ) IS
706: SELECT PLA.LOCATION_ID
707: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
708: , HZ_CUST_SITE_USES_ALL CSU
709: , HZ_CUST_ACCT_SITES_ALL CAS
710: , CSP_RS_CUST_RELATIONS RCR
711: , HZ_PARTY_SITES HPS
712: WHERE CSU.site_use_id = PLA.site_use_id
713: AND CSU.site_use_code = 'SHIP_TO'