APPS.AHL_UMP_BOM_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 251: FROM mtl_system_items_b

247: BEGIN
248: G_DEBUG_LINE_NUM := l_debug_module||': '||3052;
249: SELECT 1
250: INTO l_temp
251: FROM mtl_system_items_b
252: WHERE inventory_item_id = nrp_mat_tbl(t).INVENTORY_ITEM_ID
253: AND organization_id = p_maint_org_id;
254: EXCEPTION
255: WHEN NO_DATA_FOUND -- No match for item and UE org. So skip this item

Line 628: FROM mtl_system_items_b

624: BEGIN
625: G_DEBUG_LINE_NUM := l_debug_module||': '||4090;
626: SELECT 1
627: INTO l_temp
628: FROM mtl_system_items_b
629: WHERE INVENTORY_ITEM_ID = l_Route_Mtl_Req_Tbl(j).INVENTORY_ITEM_ID
630: AND organization_id = p_org_id;
631: EXCEPTION
632: WHEN NO_DATA_FOUND-- No match for item and UE org. So skip this item

Line 638: ' mtl_system_items_b table where p_org_id = '||p_org_id );

634: -- Log
635: G_DEBUG_LINE_NUM := l_debug_module||': '||4100;
636: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' ****************************** WARNING ******************************');
637: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' No Entries for the inventory item id and the org passed in'||
638: ' mtl_system_items_b table where p_org_id = '||p_org_id );
639: g_ret_status:=1;
640: CONTINUE;
641: END;
642: