APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on MTL_SYSTEM_ITEMS

Line 481: mtl_system_items msi,

477: INTO x_receipt_required_flag
478: FROM po_lines_interface pli,
479: po_headers_interface phi,
480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,
483: po_vendors pov,
484: po_system_parameters_all psp, --
485: financials_system_params_all fsp --

Line 530: MTL_SYSTEM_ITEMS MSI,

526: x_req_line_to_check
527: FROM PO_LINES_INTERFACE PLI,
528: PO_REQUISITION_LINES_ALL PRL, --
529: --bug 1942696 hr_location changes to reflect the new view
530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --
533: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
534: PO_VENDORS POV,

Line 619: MTL_SYSTEM_ITEMS MSI,

615: SELECT PLI.shipment_num
616: INTO x_po_shipment_num
617: FROM PO_LINES_INTERFACE PLI,
618: PO_REQUISITION_LINES_ALL PRL, --
619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
623: PO_VENDORS POV,

Line 1283: l_grade_control_flag mtl_system_items.grade_control_flag%TYPE;

1279: --pli.unit_price,
1280: 10,--pli.need_by_date,
1281: 2; --pli.requisition_line_id;
1282: --
1283: l_grade_control_flag mtl_system_items.grade_control_flag%TYPE;
1284: l_line_grade mtl_grades.grade_code%TYPE;
1285: --
1286: l_max_iface_line_num NUMBER; --
1287:

Line 1752: FROM mtl_system_items

1748:
1749: BEGIN
1750: SELECT grade_control_flag
1751: INTO l_grade_control_flag
1752: FROM mtl_system_items
1753: WHERE inventory_item_id = x_item_id
1754: AND organization_id = po_autocreate_params.g_sys.def_inv_org_id;
1755:
1756: EXCEPTION