APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on HZ_PARTY_SITE_USES

Line 1467: from hz_party_site_uses cust_party_site_use_n

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

Line 3582: from hz_party_site_uses cust_party_site_use_n

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

Line 3862: hz_party_site_uses hpu,

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

Line 5607: from hz_party_site_uses cust_party_site_use_n

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

Line 5897: hz_party_site_uses hpu,

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