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_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 131: po_line_locations_all plla ,

127: INTO po_line_loc_id_tbl ,
128: draft_id_tbl ,
129: delete_flag_tbl
130: FROM TABLE(po_line_id_tbl) pl ,
131: po_line_locations_all plla ,
132: po_lines_interface PLI ,
133: po_headers_interface phi
134: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
135: AND phi.interface_header_id = PLI.interface_header_id

Line 800: FROM po_line_locations_all poll --

796:
797: l_progress := '060';
798: SELECT NVL (MAX (shipment_num), 0)
799: INTO x_shipment_num
800: FROM po_line_locations_all poll --
801: WHERE poll.po_line_id = x_po_line_id
802: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'RFQ');
803:
804: -- We now check to see if the line_num matches as well by

Line 824: po_line_locations_all poll, --

820: l_progress := '080';
821: SELECT NVL (MAX (shipment_num), 0)
822: INTO x_shipment_num
823: FROM po_headers_all ph, --
824: po_line_locations_all poll, --
825: po_releases_all pr --
826: WHERE ph.po_header_id = poll.po_header_id
827: AND ph.segment1 = x_document_num
828: AND pr.po_header_id = ph.po_header_id

Line 2900: FROM po_line_locations_all_ext_b plle ,

2896: END IF;
2897:
2898: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2899: INTO x_attr_group_tbl
2900: FROM po_line_locations_all_ext_b plle ,
2901: ego_attr_groups_v ag ,
2902: po_uda_ag_template_usages tu
2903: WHERE plle.line_location_id = p_line_location_id_tbl(i)
2904: AND plle.attr_group_id = ag.attr_group_id