DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4371: FROM mtl_system_items_kfv

4367: BEGIN
4368: IF (x_sub_item_id_record.substitute_item_num IS NOT NULL) THEN
4369: SELECT MAX(inventory_item_id)
4370: INTO x_sub_item_id_record.substitute_item_id
4371: FROM mtl_system_items_kfv
4372: WHERE concatenated_segments = x_sub_item_id_record.substitute_item_num;
4373: ELSE
4374: SELECT MAX(inventory_item_id)
4375: INTO x_sub_item_id_record.substitute_item_id

Line 4376: FROM mtl_system_items_kfv

4372: WHERE concatenated_segments = x_sub_item_id_record.substitute_item_num;
4373: ELSE
4374: SELECT MAX(inventory_item_id)
4375: INTO x_sub_item_id_record.substitute_item_id
4376: FROM mtl_system_items_kfv
4377: WHERE concatenated_segments = x_sub_item_id_record.vendor_item_num;
4378: END IF;
4379:
4380: IF (x_sub_item_id_record.substitute_item_id IS NULL) THEN