APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 431: FROM mtl_system_items_b

427: AND l_Rel_Item_Rec.INVENTORY_ITEM_ID<>FND_API.G_MISS_NUM THEN
428:
429: BEGIN
430: SELECT 'x' INTO l_inv_item_exists
431: FROM mtl_system_items_b
432: WHERE INVENTORY_ITEM_ID = l_Rel_Item_Rec.INVENTORY_ITEM_ID
433: AND ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN

Line 450: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'

446: ,p_token_tbl => l_Token_Tbl
447: ,p_message_type => 'E'
448: ,p_entity_code => G_Entity_Code
449: ,p_entity_index => 1
450: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'
451: );
452: RAISE VALIDATION_ERROR;
453: WHEN Too_Many_Rows THEN
454: NULL;

Line 464: FROM mtl_system_items_b

460: AND l_Rel_Item_Rec.RELATED_ITEM_ID<>FND_API.G_MISS_NUM then
461:
462: BEGIN
463: SELECT 'x' INTO l_rel_item_exists
464: FROM mtl_system_items_b
465: WHERE INVENTORY_ITEM_ID = l_Rel_Item_Rec.RELATED_ITEM_ID
466: AND ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID;
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN

Line 483: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'

479: ,p_token_tbl => l_Token_Tbl
480: ,p_message_type => 'E'
481: ,p_entity_code => G_Entity_Code
482: ,p_entity_index => 1
483: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'
484: );
485: RAISE VALIDATION_ERROR;
486: END;
487: END IF;

Line 495: FROM mtl_system_items_b

491: AND l_Rel_Item_Rec.RELATED_ITEM_ID_UPD_VAL <>FND_API.G_MISS_NUM then
492:
493: BEGIN
494: SELECT 'x' INTO l_rel_item_exists
495: FROM mtl_system_items_b
496: WHERE INVENTORY_ITEM_ID = l_Rel_Item_Rec.RELATED_ITEM_ID_UPD_VAL
497: AND ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID;
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN

Line 514: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'

510: ,p_token_tbl => l_Token_Tbl
511: ,p_message_type => 'E'
512: ,p_entity_code => G_Entity_Code
513: ,p_entity_index => 1
514: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'
515: );
516: RAISE VALIDATION_ERROR;
517: END;
518: END IF;

Line 2343: FROM mtl_system_items_b_kfv msk

2339:
2340: BEGIN
2341:
2342: SELECT msk.inventory_item_id into p_related_item_id
2343: FROM mtl_system_items_b_kfv msk
2344: WHERE msk.concatenated_segments = l_mtl_Rel_Item_rec.RELATED_ITEM_NUMBER
2345: and rownum=1;
2346:
2347: IF l_mtl_Rel_Item_rec.RELATED_ITEM_ID IS NOT NULL THEN

Line 2396: FROM mtl_system_items_b_kfv msk

2392:
2393: BEGIN
2394:
2395: SELECT msk.inventory_item_id into p_inventory_item_id
2396: FROM mtl_system_items_b_kfv msk
2397: WHERE msk.concatenated_segments = l_mtl_Rel_Item_rec.ITEM_NUMBER
2398: and organization_id=l_mtl_Rel_Item_rec.ORGANIZATION_ID;
2399:
2400: IF l_mtl_Rel_Item_rec.INVENTORY_ITEM_ID IS NOT NULL THEN