DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_ITEM_REVISIONS_ORG_VAL_V

Line 643: FROM mtl_item_revisions_org_val_v mir

639: -- Check whether revision is still active
640:
641: SELECT NVL(MAX(inventory_item_id), 0) -- does this accurately check for active revisions??
642: INTO x_inventory_item
643: FROM mtl_item_revisions_org_val_v mir
644: WHERE mir.inventory_item_id = x_item_revision_record.item_id
645: AND mir.organization_id = NVL(x_item_revision_record.to_organization_id, mir.organization_id)
646: AND mir.revision = x_item_revision_record.item_revision;
647: