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_PARTY_SITES

Line 43: , HZ_PARTY_SITES HPS

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
46: AND CSU.site_use_id = PLA.site_use_id
47: AND CSU.site_use_code = 'SHIP_TO'

Line 129: , HZ_PARTY_SITES HPS

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
132: AND CSU.site_use_code = 'SHIP_TO'
133: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id

Line 205: -- HZ_PARTY_SITES ( ALSO HZ_LOCATIONS IS FILLED BY THIS HOOK )

201: , P_PK1_NUM_VALUE => p_location_id
202: , P_RESOURCE_ID => l_resource_id
203: );
204:
205: -- HZ_PARTY_SITES ( ALSO HZ_LOCATIONS IS FILLED BY THIS HOOK )
206: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( r_location_ids.HPS_ID, l_resource_id );
207: END IF;
208: CLOSE c_location_ids;
209:

Line 206: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( r_location_ids.HPS_ID, l_resource_id );

202: , P_RESOURCE_ID => l_resource_id
203: );
204:
205: -- HZ_PARTY_SITES ( ALSO HZ_LOCATIONS IS FILLED BY THIS HOOK )
206: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( r_location_ids.HPS_ID, l_resource_id );
207: END IF;
208: CLOSE c_location_ids;
209:
210: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 235: , HZ_PARTY_SITES HPS

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
238: AND CSU.site_use_id = PLA.site_use_id
239: AND CSU.site_use_code = 'SHIP_TO'

Line 335: -- HZ_PARTY_SITES

331: ,g_acc_table_name4
332: ,l_resource_id
333: ,l_pla_acc_id
334: );
335: -- HZ_PARTY_SITES
336: CSL_HZ_PARTY_SITES_ACC_PKG.UPDATE_PARTY_SITE( r_location_ids.HPS_ID );
337:
338: -- HZ_LOCATIONS
339: CSL_HZ_LOCATIONS_ACC_PKG.UPDATE_LOCATION( r_location_ids.HZL_ID );

Line 336: CSL_HZ_PARTY_SITES_ACC_PKG.UPDATE_PARTY_SITE( r_location_ids.HPS_ID );

332: ,l_resource_id
333: ,l_pla_acc_id
334: );
335: -- HZ_PARTY_SITES
336: CSL_HZ_PARTY_SITES_ACC_PKG.UPDATE_PARTY_SITE( r_location_ids.HPS_ID );
337:
338: -- HZ_LOCATIONS
339: CSL_HZ_LOCATIONS_ACC_PKG.UPDATE_LOCATION( r_location_ids.HZL_ID );
340: END IF;

Line 369: , HZ_PARTY_SITES HPS

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
372: AND CSU.site_use_code = 'SHIP_TO'
373: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id

Line 473: , 'Calling CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site'

469: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
470: jtm_message_log_pkg.Log_Msg
471: ( p_resource_id
472: , g_table_name
473: , 'Calling CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site'
474: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
475: END IF;
476:
477: CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site( r_location_ids.HPS_ID, p_resource_id );

Line 477: CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site( r_location_ids.HPS_ID, p_resource_id );

473: , 'Calling CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site'
474: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
475: END IF;
476:
477: CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site( r_location_ids.HPS_ID, p_resource_id );
478: END IF;
479: CLOSE c_location_ids;
480:
481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 661: , HZ_PARTY_SITES HPS

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'
664: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id
665: AND CAS.cust_account_id = RCR.customer_id

Line 711: , HZ_PARTY_SITES HPS

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'
714: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id
715: AND CAS.cust_account_id = RCR.customer_id