DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_ITEM_REVISIONS_B

Line 2950: FROM MTL_ITEM_REVISIONS_B mir --Bug 5217526. Earlier using mtl_item_revisions_org_val_v

2946: -- Check whether revision is still active
2947:
2948: SELECT NVL(MAX(inventory_item_id), 0) -- does this accurately check for active revisions??
2949: INTO x_inventory_item
2950: FROM MTL_ITEM_REVISIONS_B mir --Bug 5217526. Earlier using mtl_item_revisions_org_val_v
2951: WHERE mir.inventory_item_id = x_item_revision_record.item_id
2952: AND mir.organization_id = NVL(x_item_revision_record.to_organization_id, mir.organization_id)
2953: AND mir.revision = x_item_revision_record.item_revision;
2954: