APPS.RCV_DEFAULT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 938: * So, we have to fetch the description from mtl_system_items_vl instead of

934: RETURN NULL;
935: END IF;
936: /** Bug: 5504176
937: * Item description field is MLS(multi lingual support) complaint field.
938: * So, we have to fetch the description from mtl_system_items_vl instead of
939: * mtl_item_flexfields, because mtl_system_items_vl view is based on
940: * mtl_system_items_tl table.
941: */
942: SELECT description

Line 939: * mtl_item_flexfields, because mtl_system_items_vl view is based on

935: END IF;
936: /** Bug: 5504176
937: * Item description field is MLS(multi lingual support) complaint field.
938: * So, we have to fetch the description from mtl_system_items_vl instead of
939: * mtl_item_flexfields, because mtl_system_items_vl view is based on
940: * mtl_system_items_tl table.
941: */
942: SELECT description
943: INTO x_item_description

Line 940: * mtl_system_items_tl table.

936: /** Bug: 5504176
937: * Item description field is MLS(multi lingual support) complaint field.
938: * So, we have to fetch the description from mtl_system_items_vl instead of
939: * mtl_item_flexfields, because mtl_system_items_vl view is based on
940: * mtl_system_items_tl table.
941: */
942: SELECT description
943: INTO x_item_description
944: FROM mtl_system_items_vl --5504176

Line 944: FROM mtl_system_items_vl --5504176

940: * mtl_system_items_tl table.
941: */
942: SELECT description
943: INTO x_item_description
944: FROM mtl_system_items_vl --5504176
945: WHERE organization_id = p_org_id
946: AND inventory_item_id = p_item_id;
947:
948: RETURN x_item_description;

Line 7108: FROM mtl_system_items

7104: SELECT lot_control_code,
7105: serial_number_control_code
7106: INTO rti.use_mtl_lot,
7107: rti.use_mtl_serial
7108: FROM mtl_system_items
7109: WHERE mtl_system_items.inventory_item_id = rti.item_id
7110: AND mtl_system_items.organization_id = rti.to_organization_id;
7111: END IF;
7112: EXCEPTION

Line 7109: WHERE mtl_system_items.inventory_item_id = rti.item_id

7105: serial_number_control_code
7106: INTO rti.use_mtl_lot,
7107: rti.use_mtl_serial
7108: FROM mtl_system_items
7109: WHERE mtl_system_items.inventory_item_id = rti.item_id
7110: AND mtl_system_items.organization_id = rti.to_organization_id;
7111: END IF;
7112: EXCEPTION
7113: WHEN OTHERS THEN

Line 7110: AND mtl_system_items.organization_id = rti.to_organization_id;

7106: INTO rti.use_mtl_lot,
7107: rti.use_mtl_serial
7108: FROM mtl_system_items
7109: WHERE mtl_system_items.inventory_item_id = rti.item_id
7110: AND mtl_system_items.organization_id = rti.to_organization_id;
7111: END IF;
7112: EXCEPTION
7113: WHEN OTHERS THEN
7114: asn_debug.put_line ('Unable to default use_mtl_lot and use_mtl_serial');