DBA Data[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1473: hz_cust_acct_sites_all cust_cust_acct_site,

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
1477: (select

Line 1647: hz_cust_acct_sites_all cas,

1643: po_vendors pov,
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

Line 3588: hz_cust_acct_sites_all cust_cust_acct_site,

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
3592: (select

Line 3758: hz_cust_acct_sites_all cas,

3754: po_vendors pov,
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

Line 5613: hz_cust_acct_sites_all cust_cust_acct_site,

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
5617: (select

Line 5739: hz_cust_acct_sites_all cas,

5735: po_vendors pov,
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