DBA Data[Home] [Help]

APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_ITEM_REVISIONS_VL

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;