APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_TXL_ITM_INSTS

Line 1748: okl_txl_itm_insts iti,

1744: row_number() over ( partition by cle_inst.cle_id
1745: order by iti.object_id1_new nulls last ) instal_site_row_num
1746: from hz_locations hl,
1747: hz_party_sites hps,
1748: okl_txl_itm_insts iti,
1749: csi_item_instances csi,
1750: okc_k_items cim_ib,
1751: okc_k_lines_b cle_ib,
1752: okc_k_lines_b cle_inst,

Line 1778: okl_txl_itm_insts iti

1774: cleb_inst.cle_id,
1775: cleb_inst.dnz_chr_id
1776: FROM okc_k_lines_b cleb_inst,
1777: okc_k_lines_b cleb_ib,
1778: okl_txl_itm_insts iti
1779: WHERE cleb_inst.lse_id = 43
1780: AND cleb_ib.cle_id = cleb_inst.id
1781: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id
1782: AND cleb_ib.lse_id = 45

Line 3859: okl_txl_itm_insts iti,

3855: row_number() over ( partition by cleb_inst.cle_id
3856: order by iti.object_id1_new nulls last ) instal_site_row_num
3857: FROM okc_k_lines_b cleb_inst,
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

Line 3883: okl_txl_itm_insts iti

3879: cleb_inst.cle_id,
3880: cleb_inst.dnz_chr_id
3881: FROM okc_k_lines_b cleb_inst,
3882: okc_k_lines_b cleb_ib,
3883: okl_txl_itm_insts iti
3884: WHERE cleb_inst.lse_id = 43
3885: AND cleb_ib.cle_id = cleb_inst.id
3886: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id
3887: AND cleb_ib.lse_id = 45

Line 5842: okl_txl_itm_insts iti,

5838: row_number() over ( partition by cle_inst.cle_id
5839: order by iti.object_id1_new nulls last ) instal_site_row_num
5840: from hz_locations hl,
5841: hz_party_sites hps,
5842: okl_txl_itm_insts iti,
5843: csi_item_instances csi,
5844: okc_k_items cim_ib,
5845: okc_k_lines_b cle_ib,
5846: okc_k_lines_b cle_inst,

Line 5894: okl_txl_itm_insts iti,

5890: row_number() over ( partition by cleb_inst.cle_id
5891: order by iti.object_id1_new nulls last ) instal_site_row_num
5892: FROM okc_k_lines_b cleb_inst,
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

Line 5919: okl_txl_itm_insts iti

5915: cleb_inst.cle_id,
5916: cleb_inst.dnz_chr_id
5917: FROM okc_k_lines_b cleb_inst,
5918: okc_k_lines_b cleb_ib,
5919: okl_txl_itm_insts iti
5920: WHERE cleb_inst.lse_id = 43
5921: AND cleb_ib.cle_id = cleb_inst.id
5922: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id
5923: AND cleb_ib.lse_id = 45