APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1665: g_chktype_TRACKING_QTY_IND CONSTANT MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE := 'PS';

1661: l_shipto_prf VARCHAR2(1);
1662: x_quote_header_id NUMBER := NULL;
1663: x_quote_line_id NUMBER := NULL;
1664: l_routing_name VARCHAR2 (100);
1665: g_chktype_TRACKING_QTY_IND CONSTANT MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE := 'PS';
1666: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL;
1667: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;
1668: l_uom_convert VARCHAR2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
1669: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;

Line 2145: FROM mtl_system_items msi

2141: INTO p_lines.it_invoice_tolerance_tbl(i),
2142: p_lines.it_rcv_tolerance_tbl(i),
2143: p_lines.it_inspect_req_flag_tbl(i),
2144: p_lines.it_receipt_req_flag_tbl(i)
2145: FROM mtl_system_items msi
2146: WHERE msi.inventory_item_id = p_lines.item_id_tbl(i)
2147: AND msi.organization_id = p_lines.dest_organization_id_tbl(i);
2148: EXCEPTION
2149: WHEN no_data_found THEN

Line 2191: FROM mtl_system_items msi

2187: p_lines.it_invoice_tolerance_tbl(i),
2188: p_lines.it_rcv_tolerance_tbl(i),
2189: p_lines.it_secondary_uom_code_tbl(i), --
2190: p_lines.it_grade_control_flag_tbl(i) --
2191: FROM mtl_system_items msi
2192: WHERE msi.inventory_item_id = p_lines.item_id_tbl(i)
2193: AND msi.organization_id = po_autocreate_params.g_sys.master_inv_org_id;
2194:
2195: IF g_debug_stmt THEN

Line 2437: FROM mtl_system_items

2433: SELECT un_number_id,
2434: hazard_class_id
2435: INTO x_un_number_id,
2436: x_hazard_class_id
2437: FROM mtl_system_items
2438: WHERE inventory_item_id = p_lines.item_id_tbl(i)
2439: AND organization_id = po_autocreate_params.g_sys.master_inv_org_id;
2440: EXCEPTION
2441: WHEN no_data_found THEN