DBA Data[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1471: hz_cust_site_uses_all cust_cust_site_use,

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

Line 1647: hz_cust_site_uses_all csu

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

Line 3586: hz_cust_site_uses_all cust_cust_site_use,

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

Line 3758: hz_cust_site_uses_all csu

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

Line 5611: hz_cust_site_uses_all cust_cust_site_use,

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

Line 5739: hz_cust_site_uses_all csu

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