DBA Data[Home] [Help]

APPS.OKL_DEAL_ASSET_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1036: hz_cust_site_uses_all csu

1032: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1033: FROM hz_locations hl,
1034: hz_party_sites hps,
1035: hz_cust_acct_sites_all cas,
1036: hz_cust_site_uses_all csu
1037: WHERE csu.site_use_id = p_site_use_id
1038: AND cas.cust_acct_site_id = csu.cust_acct_site_id
1039: AND hps.party_site_id = cas.party_site_id
1040: AND hl.location_id = hps.location_id;

Line 1354: hz_cust_site_uses_all csu ,

1350: clet_fin.item_description,
1351: cleb_fin.bill_to_site_use_id,
1352: csu.location bill_to_site_name
1353: FROM okc_k_lines_b cleb_fin,
1354: hz_cust_site_uses_all csu ,
1355: okc_k_lines_tl clet_fin
1356: WHERE cleb_fin.id = p_cle_id
1357: AND csu.site_use_id = cleb_fin.bill_to_site_use_id
1358: AND clet_fin.id = cleb_fin.id