APPS.CSI_FA_INSTANCE_GRP dependencies on MTL_SYSTEM_ITEMS

Line 153: FROM mtl_system_items

149: serial_number_control_code
150: INTO l_asset_creation_code,
151: l_inventory_item,
152: l_serial_code
153: FROM mtl_system_items
154: WHERE inventory_item_id = l_inventory_item_id
155: AND organization_id = l_organization_id;
156:
157: IF nvl(l_asset_creation_code,'0') in ('1', 'Y') THEN

Line 478: FROM mtl_system_items

474: SELECT eam_item_type,
475: serial_number_control_code
476: INTO l_eam_item_type,
477: l_serial_control_code
478: FROM mtl_system_items
479: WHERE inventory_item_id = p_instance_rec.inventory_item_id
480: AND organization_id = p_instance_rec.vld_organization_id;
481:
482: IF l_eam_item_type in (1, 3) AND l_serial_control_code <> 1 THEN

Line 1013: FROM mtl_system_items

1009: SELECT eam_item_type,
1010: serial_number_control_code
1011: INTO l_eam_item_type,
1012: l_serial_control_code
1013: FROM mtl_system_items
1014: WHERE inventory_item_id = p_instance_rec.inventory_item_id
1015: AND organization_id = p_instance_rec.vld_organization_id;
1016:
1017: IF l_eam_item_type in (1, 3) AND l_serial_control_code <> 1 THEN