APPS.PO_LINES_SV4 dependencies on MTL_SYSTEM_ITEMS

Line 332: FROM mtl_system_items msi

328: IF X_item_id is not null then
329: X_progress := '010';
330: SELECT nvl(msi.receipt_required_flag, X_receipt_required_flag)
331: INTO X_receipt_required_flag
332: FROM mtl_system_items msi
333: WHERE msi.inventory_item_id = X_item_id
334: AND msi.organization_id = X_inventory_org_id;
335: ELSE
336: X_progress := '020';

Line 853: from mtl_system_items_kfv

849:
850: if (X_sub_item_id_record.substitute_item_num is not null) then
851: select max(inventory_item_id)
852: into x_sub_item_id_record.substitute_item_id
853: from mtl_system_items_kfv
854: where concatenated_segments = X_sub_item_id_record.substitute_item_num;
855: else
856: select max(inventory_item_id)
857: into x_sub_item_id_record.substitute_item_id

Line 858: from mtl_system_items_kfv

854: where concatenated_segments = X_sub_item_id_record.substitute_item_num;
855: else
856: select max(inventory_item_id)
857: into x_sub_item_id_record.substitute_item_id
858: from mtl_system_items_kfv
859: where concatenated_segments = X_sub_item_id_record.vendor_item_num;
860: end if;
861:
862: if (x_sub_item_id_record.substitute_item_id is null) then