DBA Data[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKL_TXL_ITM_INSTS

Line 1749: okl_txl_itm_insts iti,

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

Line 1779: okl_txl_itm_insts iti

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

Line 3860: okl_txl_itm_insts iti,

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

Line 3884: okl_txl_itm_insts iti

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

Line 5843: okl_txl_itm_insts iti,

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

Line 5895: okl_txl_itm_insts iti,

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

Line 5920: okl_txl_itm_insts iti

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