APPS.WIP_EAM_WORKREQUEST_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1047: FROM mtl_system_items_b_kfv

1043: FROM dual;
1044: IF (l_old_asset_group_id IS NOT NULL) THEN
1045: BEGIN
1046: SELECT concatenated_segments INTO l_old_data
1047: FROM mtl_system_items_b_kfv
1048: WHERE organization_id = p_org_id
1049: AND inventory_item_id = l_old_asset_group_id;
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN

Line 1060: FROM mtl_system_items_b_kfv

1056: END IF;
1057: IF (l_new_asset_group_id IS NOT NULL) THEN
1058: BEGIN
1059: SELECT concatenated_segments INTO l_new_data
1060: FROM mtl_system_items_b_kfv
1061: WHERE organization_id = p_org_id
1062: AND inventory_item_id = l_new_asset_group_id;
1063: EXCEPTION
1064: WHEN NO_DATA_FOUND THEN

Line 2614: FROM csi_item_instances cii, mtl_system_items msi

2610: -- check that the asset is maintainable
2611:
2612: SELECT nvl(cii.maintainable_flag, 'Y'), cii.serial_number, msi.eam_item_type
2613: INTO l_dummy_char, l_asset_number,l_dummy_val
2614: FROM csi_item_instances cii, mtl_system_items msi
2615: WHERE cii.instance_id = p_maintenance_object_id AND
2616: cii.last_vld_organization_id = msi.organization_id AND
2617: cii.inventory_item_id = msi.inventory_item_id ;
2618:

Line 2647: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI

2643: -- check that the asset is maintainable
2644: -- Bug # 3553217.
2645: SELECT nvl(cii.maintainable_flag, 'Y'), eam_item_type
2646: INTO l_dummy_char, l_dummy_val
2647: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI
2648: WHERE cii.serial_number = p_asset_number AND
2649: cii.inventory_item_id = p_asset_group_id AND
2650: cii.last_vld_organization_id = msi.organization_id AND
2651: cii.inventory_item_id = msi.inventory_item_id ;

Line 2904: from mtl_system_items

2900: IF p_asset_group_id is not null then
2901: begin
2902: select eam_item_type
2903: into l_eam_item_type
2904: from mtl_system_items
2905: where inventory_item_id = p_asset_group_id
2906: and organization_id = p_org_id;
2907: exception
2908: when no_data_found then