APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_ITEM_REVISIONS

Line 486: from mtl_item_revisions_vl item_rev

482: FROM dual
483: WHERE
484: l_Xref_Rec.Revision_Id IN (
485: select item_rev.revision_id
486: from mtl_item_revisions_vl item_rev
487: where item_rev.inventory_item_id = l_XRef_Rec.Inventory_Item_Id
488: and item_rev.organization_id = l_XRef_Rec.organization_id
489: )
490: AND ROWNUM=1;

Line 923: from mtl_item_revisions_vl item_rev

919: FROM dual
920: WHERE
921: l_Xref_Rec.Revision_Id IN (
922: select item_rev.revision_id
923: from mtl_item_revisions_vl item_rev
924: where item_rev.inventory_item_id = Decode(l_XRef_Rec.Inventory_Item_Id,FND_API.G_MISS_NUM,l_mtl_XRef_rec.Inventory_Item_Id,l_XRef_Rec.Inventory_Item_Id)
925: and item_rev.organization_id = Decode(l_XRef_Rec.organization_id,FND_API.G_MISS_NUM, l_mtl_XRef_rec.Organization_Id,l_XRef_Rec.organization_id)
926: )
927: AND ROWNUM=1;

Line 1410: FROM mtl_item_revisions

1406: IF l_GTIN_XRef_Rec.ORGANIZATION_ID IS NOT NULL
1407: AND l_GTIN_XRef_Rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM THEN
1408: BEGIN
1409: SELECT 'x' INTO l_item_revision_exists
1410: FROM mtl_item_revisions
1411: WHERE INVENTORY_ITEM_ID = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID
1412: AND REVISION_ID = l_GTIN_XRef_Rec.REVISION_ID
1413: AND ORGANIZATION_ID = l_GTIN_XRef_Rec.ORGANIZATION_ID;
1414: EXCEPTION

Line 1455: FROM mtl_item_revisions

1451: END;
1452:
1453: BEGIN
1454: SELECT 'x' INTO l_item_revision_exists
1455: FROM mtl_item_revisions
1456: WHERE INVENTORY_ITEM_ID = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID
1457: AND REVISION_ID = l_GTIN_XRef_Rec.REVISION_ID
1458: AND ORGANIZATION_ID = l_master_org;
1459: EXCEPTION

Line 1877: FROM mtl_item_revisions_b

1873:
1874: BEGIN
1875:
1876: SELECT revision_id INTO p_revision_id
1877: FROM mtl_item_revisions_b
1878: WHERE inventory_item_id=l_mtl_xref_rec.INVENTORY_ITEM_ID
1879: AND organization_id= l_mtl_xref_rec.ORGANIZATION_ID
1880: AND revision= l_mtl_xref_rec.revision;
1881: