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 1645: hz_locations hl,

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

Line 1747: from hz_locations hl,

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

Line 3756: hz_locations hl,

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

Line 3861: hz_locations hl,

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

Line 5737: hz_locations hl,

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

Line 5841: from hz_locations hl,

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

Line 5896: hz_locations hl,

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