DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_ITEM_REVISIONS

Line 629: FROM mtl_item_revisions

625: END IF;
626:
627: SELECT NVL(MAX(inventory_item_id), 0)
628: INTO x_inventory_item
629: FROM mtl_item_revisions
630: WHERE inventory_item_id = x_item_revision_record.item_id
631: AND organization_id = NVL(x_item_revision_record.to_organization_id, organization_id)
632: AND revision = x_item_revision_record.item_revision;
633:

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: