DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on HZ_CUST_SITE_USES

Line 182: hz_cust_site_uses csu,

178: SELECT pla.location_id inv_loc_id,
179: hzl.time_zone
180: from csp_rs_cust_relations rcr,
181: hz_cust_acct_sites cas,
182: hz_cust_site_uses csu,
183: po_location_associations pla,
184: hz_party_sites ps,
185: hz_locations hzl
186: where rcr.customer_id = cas.cust_account_id

Line 201: hz_cust_site_uses csu,

197: SELECT pla.location_id inv_loc_id,
198: hzl.time_zone timezone_id
199: from csp_rs_cust_relations rcr,
200: hz_cust_acct_sites cas,
201: hz_cust_site_uses csu,
202: po_location_associations pla,
203: hz_party_sites ps,
204: hz_locations hzl,
205: jtf_task_assignments jta

Line 351: hz_cust_site_uses csu,

347: BEGIN
348: SELECT hzl.time_zone time_zone_id
349: INTO l_timezone_id
350: from hz_cust_acct_sites cas,
351: hz_cust_site_uses csu,
352: po_location_associations pla,
353: hz_party_sites ps,
354: hz_locations hzl
355: where cas.cust_acct_site_id = csu.cust_acct_site_id (+)