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.JMF_SUBCONTRACT_ORDERS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 323: FROM HR_ORGANIZATION_INFORMATION hoi

319: , hoi.organization_id tp_organization_id
320: , p_vendor_id vendor_id
321: , p_vendor_site_id vendor_site_id
322: , 'Y' status
323: FROM HR_ORGANIZATION_INFORMATION hoi
324: , mtl_interorg_parameters mip
325: , mtl_parameters mp
326: WHERE mip.to_organization_id = mp.organization_id
327: AND mp.organization_id = hoi.organization_id

Line 1635: FROM hr_organization_information hoi,

1631: pha.reference_num,
1632: pha.segment1,
1633: pla.line_num,
1634: plla.shipment_num
1635: FROM hr_organization_information hoi,
1636: po_line_locations_all plla,
1637: po_lines_all pla,
1638: po_headers_all pha,
1639: mtl_interorg_parameters mip,

Line 1971: FROM hr_organization_information

1967: SELECT TO_NUMBER(org_information3),
1968: TO_NUMBER(org_information4)
1969: INTO l_tp_supplier_id,
1970: l_tp_supplier_site_id
1971: FROM hr_organization_information
1972: WHERE organization_id = l_tp_organization_id
1973: AND org_information_context = 'Customer/Supplier Association';
1974:
1975: INSERT INTO JMF_SHIKYU_REPLENISHMENTS