APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on HZ_PARTY_SITE_USES

Line 1468: from hz_party_site_uses cust_party_site_use_n

1464: cust_party_site_use_n.status cpsu_status,
1465: cust_party_site_use_n.comments cpsu_comments,
1466: row_number() over ( partition by cust_party_site_use_n.party_site_id
1467: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
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,

Line 3583: from hz_party_site_uses cust_party_site_use_n

3579: cust_party_site_use_n.status cpsu_status,
3580: cust_party_site_use_n.comments cpsu_comments,
3581: row_number() over ( partition by cust_party_site_use_n.party_site_id
3582: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
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,

Line 3863: hz_party_site_uses hpu,

3859: okc_k_lines_b cleb_ib,
3860: okl_txl_itm_insts iti,
3861: hz_locations hl,
3862: hz_party_sites hps,
3863: hz_party_site_uses hpu,
3864: fnd_lookup_values_vl lookup
3865: WHERE cleb_inst.lse_id = 43
3866: AND cleb_ib.cle_id = cleb_inst.id
3867: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id

Line 5608: from hz_party_site_uses cust_party_site_use_n

5604: cust_party_site_use_n.status cpsu_status,
5605: cust_party_site_use_n.comments cpsu_comments,
5606: row_number() over ( partition by cust_party_site_use_n.party_site_id
5607: order by NVL(cust_party_site_use_n.status,'A') ASC) cpsu_stat_priority
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,

Line 5898: hz_party_site_uses hpu,

5894: okc_k_lines_b cleb_ib,
5895: okl_txl_itm_insts iti,
5896: hz_locations hl,
5897: hz_party_sites hps,
5898: hz_party_site_uses hpu,
5899: fnd_lookup_values_vl lookup
5900: WHERE cleb_inst.lse_id = 43
5901: AND cleb_ib.cle_id = cleb_inst.id
5902: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id