DBA Data[Home] [Help]

APPS.PO_LINES_SV4 dependencies on MTL_SYSTEM_ITEMS

Line 327: FROM mtl_system_items msi

323: IF X_item_id is not null then
324: X_progress := '010';
325: SELECT nvl(msi.receipt_required_flag, X_receipt_required_flag)
326: INTO X_receipt_required_flag
327: FROM mtl_system_items msi
328: WHERE msi.inventory_item_id = X_item_id
329: AND msi.organization_id = X_inventory_org_id;
330: ELSE
331: X_progress := '020';

Line 848: from mtl_system_items_kfv

844:
845: if (X_sub_item_id_record.substitute_item_num is not null) then
846: select max(inventory_item_id)
847: into x_sub_item_id_record.substitute_item_id
848: from mtl_system_items_kfv
849: where concatenated_segments = X_sub_item_id_record.substitute_item_num;
850: else
851: select max(inventory_item_id)
852: into x_sub_item_id_record.substitute_item_id

Line 853: from mtl_system_items_kfv

849: where concatenated_segments = X_sub_item_id_record.substitute_item_num;
850: else
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.vendor_item_num;
855: end if;
856:
857: if (x_sub_item_id_record.substitute_item_id is null) then