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.PO_OTM_INTEGRATION_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 245: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;

241: l_command VARCHAR2(30);
242:
243: l_doc_revision NUMBER;
244: l_blanket_revision PO_HEADERS_ALL.revision_num%TYPE;
245: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;
246: l_po_number PO_HEADERS_ALL.segment1%TYPE;
247: l_release_number PO_RELEASES_ALL.release_num%TYPE;
248: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
249: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --

Line 412: , hr_all_organization_units hou

408: , l_doc_revision
409: , l_org_name
410: FROM po_headers_archive_all poha
411: , po_releases_archive_all pora
412: , hr_all_organization_units hou
413: WHERE pora.po_release_id = p_doc_id
414: AND pora.latest_external_flag = 'Y'
415: AND poha.po_header_id = pora.po_header_id
416: AND poha.latest_external_flag = 'Y'

Line 428: , hr_all_organization_units hou

424: INTO l_po_number
425: , l_doc_revision
426: , l_org_name
427: FROM po_headers_archive_all poha
428: , hr_all_organization_units hou
429: WHERE poha.po_header_id = p_doc_id
430: AND poha.latest_external_flag = 'Y'
431: AND hou.organization_id = poha.org_id;
432: ELSE

Line 829: , hr_all_organization_units hou

825: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
826: FROM po_headers_archive_all poha
827: , po_lines_archive_all pola
828: , po_line_locations_archive_all plla
829: , hr_all_organization_units hou
830: , hr_locations_all hrl
831: , mtl_system_items_kfv msik
832: , mtl_units_of_measure muom
833: , financials_system_params_all fsp

Line 964: , hr_all_organization_units hou

960: , po_vendors pov
961: , po_vendor_sites_all povs
962: , fnd_territories fter
963: , po_vendor_contacts povc
964: , hr_all_organization_units hou
965: , hr_locations_all hrl
966: , per_all_people_f ppf
967: , hr_locations_all hrl2
968: , ap_terms apt

Line 1397: , hr_all_organization_units hou

1393: INTO x_otm_doc.po_header_id
1394: , x_otm_doc.po_number
1395: , x_otm_doc.org_name
1396: FROM po_headers_archive_all poha
1397: , hr_all_organization_units hou
1398: WHERE poha.po_header_id = p_doc_id
1399: AND poha.revision_num = p_doc_revision
1400: AND poha.org_id = hou.organization_id
1401: AND NVL(poha.consigned_consumption_flag, 'N') = 'N'

Line 1508: , hr_all_organization_units hou

1504: INTO x_otm_doc.po_header_id
1505: , x_otm_doc.po_number
1506: , x_otm_doc.org_name
1507: FROM po_headers_archive_all poha
1508: , hr_all_organization_units hou
1509: WHERE poha.po_header_id = p_doc_id
1510: AND poha.revision_num = p_doc_revision
1511: AND poha.org_id = hou.organization_id
1512: AND NVL(poha.consigned_consumption_flag, 'N') = 'N'

Line 1585: , hr_all_organization_units hou

1581: FROM po_headers_archive_all poha
1582: , po_releases_archive_all pora
1583: , po_lines_archive_all pola
1584: , po_line_locations_archive_all plla
1585: , hr_all_organization_units hou
1586: , hr_locations_all hrl
1587: , mtl_system_items_kfv msik
1588: , mtl_units_of_measure muom
1589: , financials_system_params_all fsp

Line 1729: , hr_all_organization_units hou

1725: , po_vendors pov
1726: , po_vendor_sites_all povs
1727: , fnd_territories fter
1728: , po_vendor_contacts povc
1729: , hr_all_organization_units hou
1730: , hr_locations_all hrl
1731: , per_all_people_f ppf
1732: , hr_locations_all hrl2
1733: , ap_terms apt

Line 2173: , hr_all_organization_units hou

2169: , x_otm_doc.release_number
2170: , x_otm_doc.org_name
2171: FROM po_headers_archive_all poha
2172: , po_releases_archive_all pora
2173: , hr_all_organization_units hou
2174: WHERE pora.po_release_id = p_doc_id
2175: AND pora.revision_num = p_doc_revision
2176: AND poha.po_header_id = pora.po_header_id
2177: AND poha.revision_num = p_blanket_revision

Line 2289: , hr_all_organization_units hou

2285: , x_otm_doc.release_number
2286: , x_otm_doc.org_name
2287: FROM po_headers_archive_all poha
2288: , po_releases_all por
2289: , hr_all_organization_units hou
2290: WHERE por.po_release_id = p_doc_id
2291: AND poha.po_header_id = por.po_header_id
2292: AND poha.revision_num = p_blanket_revision
2293: AND poha.org_id = hou.organization_id

Line 2796: hr_all_organization_units HOU,

2792: l_header_closed_code,
2793: l_header_user_hold_flag,
2794: l_inv_org_id
2795: FROM po_headers_all POH,
2796: hr_all_organization_units HOU,
2797: financials_system_params_all FSP
2798: WHERE POH.po_header_id = p_doc_id
2799: AND POH.org_id = HOU.organization_id
2800: AND POH.org_id = FSP.org_id

Line 2959: hr_all_organization_units HOU,

2955: l_header_user_hold_flag,
2956: l_inv_org_id
2957: FROM po_releases_all POR,
2958: po_headers_all POH,
2959: hr_all_organization_units HOU,
2960: financials_system_params_all FSP
2961: WHERE POR.po_release_id = p_doc_id
2962: AND POR.po_header_id = POH.po_header_id
2963: AND POR.org_id = HOU.organization_id