eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on HZ_LOCATIONS

Line 1644: hz_locations hl,

1640: FROM okl_supp_invoice_dtls inv,
1641: okc_k_party_roles_b cpl,
1642: po_vendors pov,
1643: okc_k_lines_b cle,
1644: hz_locations hl,
1645: hz_party_sites hps,
1646: hz_cust_acct_sites_all cas,
1647: hz_cust_site_uses_all csu
1648: WHERE inv.cle_id (+)= cpl.cle_id

Line 1746: from hz_locations hl,

1742: csi.serial_number SERIAL_NUMBER ,
1743: lookup.MEANING MULTIPLE,
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,

Line 3755: hz_locations hl,

3751: FROM okl_supp_invoice_dtls inv,
3752: okc_k_party_roles_b cpl,
3753: po_vendors pov,
3754: okc_k_lines_b cle,
3755: hz_locations hl,
3756: hz_party_sites hps,
3757: hz_cust_acct_sites_all cas,
3758: hz_cust_site_uses_all csu
3759: WHERE inv.cle_id (+)= cpl.cle_id

Line 3860: hz_locations hl,

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
3864: WHERE cleb_inst.lse_id = 43

Line 5736: hz_locations hl,

5732: FROM okl_supp_invoice_dtls inv,
5733: okc_k_party_roles_b cpl,
5734: po_vendors pov,
5735: okc_k_lines_b cle,
5736: hz_locations hl,
5737: hz_party_sites hps,
5738: hz_cust_acct_sites_all cas,
5739: hz_cust_site_uses_all csu
5740: WHERE inv.cle_id (+)= cpl.cle_id

Line 5840: from hz_locations hl,

5836: csi.serial_number SERIAL_NUMBER ,
5837: lookup.MEANING MULTIPLE,
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,

Line 5895: hz_locations hl,

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
5899: WHERE cleb_inst.lse_id = 43