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_SITE_USES_ALL

Line 15: -- HZ_CUST_SITE_USES_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
16: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_SITE_USES_ALL_ACC';
17: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
18: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CUST_SITE_USES');
19: g_pk1_name3 CONSTANT VARCHAR2(30) := 'SITE_USE_ID';

Line 16: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_SITE_USES_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
16: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_SITE_USES_ALL_ACC';
17: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
18: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CUST_SITE_USES');
19: g_pk1_name3 CONSTANT VARCHAR2(30) := 'SITE_USE_ID';
20: -- PO_LOCATION_ASSOCIATIONS_ALL

Line 40: , HZ_CUST_SITE_USES_ALL CSU

36: SELECT PLA.location_id LOCATION_ID
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

Line 126: , HZ_CUST_SITE_USES_ALL CSU

122: , RCR.RS_CUST_RELATION_ID RCR_ID
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

Line 188: -- HZ_CUST_SITE_USES_ALL

184: , P_PK1_NAME => g_pk1_name2
185: , P_PK1_NUM_VALUE => r_location_ids.CAS_ID
186: , P_RESOURCE_ID => l_resource_id
187: );
188: -- HZ_CUST_SITE_USES_ALL
189: JTM_HOOK_UTIL_PKG.Insert_Acc
190: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
191: , P_ACC_TABLE_NAME => g_acc_table_name3
192: , P_PK1_NAME => g_pk1_name3

Line 232: , HZ_CUST_SITE_USES_ALL CSU

228: , HPS.party_site_id HPS_ID
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

Line 311: -- HZ_CUST_SITE_USES_ALL

307: ,g_acc_table_name2
308: ,l_resource_id
309: ,l_cas_acc_id
310: );
311: -- HZ_CUST_SITE_USES_ALL
312: l_csu_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id(
313: P_ACC_TABLE_NAME => g_acc_table_name3
314: , P_PK1_NAME => g_pk1_name3
315: , P_PK1_NUM_VALUE => r_location_ids.CSU_ID

Line 366: , HZ_CUST_SITE_USES_ALL CSU

362: , RCR.RS_CUST_RELATION_ID RCR_ID
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

Line 443: , 'Delete HZ_CUST_SITE_USES_ALL acc record for user: ' || p_resource_id

439: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
440: jtm_message_log_pkg.Log_Msg
441: ( p_resource_id
442: , g_table_name
443: , 'Delete HZ_CUST_SITE_USES_ALL acc record for user: ' || p_resource_id
444: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
445: END IF;
446: JTM_HOOK_UTIL_PKG.Delete_Acc
447: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3

Line 658: , HZ_CUST_SITE_USES_ALL CSU

654: IS
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

Line 708: , HZ_CUST_SITE_USES_ALL CSU

704: IS
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