DBA Data[Home] [Help]

APPS.OKL_DEAL_ASSET_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1087: hz_cust_site_uses_all csu

1083: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1084: FROM hz_locations hl,
1085: hz_party_sites hps,
1086: hz_cust_acct_sites_all cas,
1087: hz_cust_site_uses_all csu
1088: WHERE csu.site_use_id = p_site_use_id
1089: AND cas.cust_acct_site_id = csu.cust_acct_site_id
1090: AND hps.party_site_id = cas.party_site_id
1091: AND hl.location_id = hps.location_id;

Line 1416: hz_cust_site_uses_all csu ,

1412: clet_fin.item_description,
1413: cleb_fin.bill_to_site_use_id,
1414: csu.location bill_to_site_name
1415: FROM okc_k_lines_b cleb_fin,
1416: hz_cust_site_uses_all csu ,
1417: okc_k_lines_tl clet_fin
1418: WHERE cleb_fin.id = p_cle_id
1419: AND csu.site_use_id = cleb_fin.bill_to_site_use_id
1420: AND clet_fin.id = cleb_fin.id