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 7146: FROM mtl_system_items

7142: SELECT lot_control_code,
7143: serial_number_control_code
7144: INTO rti.use_mtl_lot,
7145: rti.use_mtl_serial
7146: FROM mtl_system_items
7147: WHERE mtl_system_items.inventory_item_id = rti.item_id
7148: AND mtl_system_items.organization_id = rti.to_organization_id;
7149: END IF;
7150: EXCEPTION

Line 7147: WHERE mtl_system_items.inventory_item_id = rti.item_id

7143: serial_number_control_code
7144: INTO rti.use_mtl_lot,
7145: rti.use_mtl_serial
7146: FROM mtl_system_items
7147: WHERE mtl_system_items.inventory_item_id = rti.item_id
7148: AND mtl_system_items.organization_id = rti.to_organization_id;
7149: END IF;
7150: EXCEPTION
7151: WHEN OTHERS THEN

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

7144: INTO rti.use_mtl_lot,
7145: rti.use_mtl_serial
7146: FROM mtl_system_items
7147: WHERE mtl_system_items.inventory_item_id = rti.item_id
7148: AND mtl_system_items.organization_id = rti.to_organization_id;
7149: END IF;
7150: EXCEPTION
7151: WHEN OTHERS THEN
7152: asn_debug.put_line ('Unable to default use_mtl_lot and use_mtl_serial');