APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 235: FROM mtl_system_items_b

231: AND l_XRef_Rec.Inventory_Item_Id<>FND_API.G_MISS_NUM then
232:
233: BEGIN
234: SELECT 'x' INTO l_exists
235: FROM mtl_system_items_b
236: WHERE inventory_item_id =l_XRef_Rec.Inventory_Item_Id;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;

Line 247: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'

243: ,p_application_id => 'INV'
244: ,p_message_type => 'E'
245: ,p_entity_code => G_Entity_Code
246: ,p_entity_index => l_Xref_Indx
247: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'
248: );
249: RAISE VALIDATION_ERROR;
250: WHEN Too_Many_Rows THEN
251: NULL;

Line 386: FROM mtl_system_items_b

382: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN
383:
384: BEGIN
385: SELECT 'x' INTO l_exists
386: FROM mtl_system_items_b
387: WHERE Inventory_item_id = l_XRef_Rec.Inventory_Item_Id
388: AND Organization_id = l_XRef_Rec.Organization_Id;
389: EXCEPTION
390: WHEN NO_DATA_FOUND THEN

Line 399: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'

395: ,p_application_id => 'INV'
396: ,p_message_type => 'E'
397: ,p_entity_code => G_Entity_Code
398: ,p_entity_index => l_Xref_Indx
399: ,p_table_name => 'MTL_SYSTEM_ITEMS_B'
400: );
401: RAISE VALIDATION_ERROR;
402: END;
403: END IF ;

Line 827: FROM mtl_system_items_b

823: AND l_XRef_Rec.Inventory_Item_Id <>FND_API.G_MISS_NUM THEN
824:
825: BEGIN
826: SELECT 'x' INTO l_exists
827: FROM mtl_system_items_b
828: WHERE Inventory_item_id = l_XRef_Rec.Inventory_Item_Id
829: AND Organization_id = l_XRef_Rec.Organization_Id;
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN

Line 1435: FROM mtl_parameters p, mtl_system_items_b i

1431: --
1432: IF l_GTIN_XRef_Rec.ORG_INDEPENDENT_FLAG = 'Y' THEN
1433: BEGIN
1434: SELECT i.organization_id INTO l_master_org
1435: FROM mtl_parameters p, mtl_system_items_b i
1436: WHERE p.organization_id = p.master_organization_id
1437: AND i.organization_id = p.organization_id
1438: AND i.inventory_item_id = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID;
1439: EXCEPTION

Line 1820: FROM mtl_system_items_b_kfv msk

1816:
1817: BEGIN
1818:
1819: SELECT msk.inventory_item_id into p_inventory_item_id
1820: FROM mtl_system_items_b_kfv msk
1821: WHERE msk.concatenated_segments = l_mtl_xref_rec.ITEM_NUMBER
1822: and organization_id=l_mtl_xref_rec.ORGANIZATION_ID;
1823:
1824: IF l_mtl_xref_rec.INVENTORY_ITEM_ID IS NOT NULL THEN