DBA Data[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1472: hz_cust_site_uses_all cust_cust_site_use,

1468: from hz_party_site_uses cust_party_site_use_n
1469: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
1470: ) where cpsu_stat_priority = 1) cust_party_site_use,
1471:
1472: hz_cust_site_uses_all cust_cust_site_use,
1473: hz_cust_acct_sites_all cust_cust_acct_site,
1474:
1475:
1476: -- sales tax

Line 1648: hz_cust_site_uses_all csu

1644: okc_k_lines_b cle,
1645: hz_locations hl,
1646: hz_party_sites hps,
1647: hz_cust_acct_sites_all cas,
1648: hz_cust_site_uses_all csu
1649: WHERE inv.cle_id (+)= cpl.cle_id
1650: AND cpl.rle_code = 'OKL_VENDOR'
1651: AND cpl.chr_id is NULL
1652: AND pov.vendor_id = cpl.object1_id1

Line 3587: hz_cust_site_uses_all cust_cust_site_use,

3583: from hz_party_site_uses cust_party_site_use_n
3584: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
3585: ) where cpsu_stat_priority = 1) cust_party_site_use,
3586:
3587: hz_cust_site_uses_all cust_cust_site_use,
3588: hz_cust_acct_sites_all cust_cust_acct_site,
3589:
3590:
3591: -- sales tax

Line 3759: hz_cust_site_uses_all csu

3755: okc_k_lines_b cle,
3756: hz_locations hl,
3757: hz_party_sites hps,
3758: hz_cust_acct_sites_all cas,
3759: hz_cust_site_uses_all csu
3760: WHERE inv.cle_id (+)= cpl.cle_id
3761: AND cpl.rle_code = 'OKL_VENDOR'
3762: AND cpl.chr_id is NULL
3763: AND pov.vendor_id = cpl.object1_id1

Line 5612: hz_cust_site_uses_all cust_cust_site_use,

5608: from hz_party_site_uses cust_party_site_use_n
5609: where cust_party_site_use_n.SITE_USE_TYPE = 'BILL_TO'
5610: ) where cpsu_stat_priority = 1) cust_party_site_use,
5611:
5612: hz_cust_site_uses_all cust_cust_site_use,
5613: hz_cust_acct_sites_all cust_cust_acct_site,
5614:
5615:
5616: -- sales tax

Line 5740: hz_cust_site_uses_all csu

5736: okc_k_lines_b cle,
5737: hz_locations hl,
5738: hz_party_sites hps,
5739: hz_cust_acct_sites_all cas,
5740: hz_cust_site_uses_all csu
5741: WHERE inv.cle_id (+)= cpl.cle_id
5742: AND cpl.rle_code = 'OKL_VENDOR'
5743: AND cpl.chr_id is NULL
5744: AND pov.vendor_id = cpl.object1_id1