DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_ITEM_REVISIONS

Line 2936: FROM mtl_item_revisions

2932: END IF;
2933:
2934: SELECT NVL(MAX(inventory_item_id), 0)
2935: INTO x_inventory_item
2936: FROM mtl_item_revisions
2937: WHERE inventory_item_id = x_item_revision_record.item_id
2938: AND organization_id = NVL(x_item_revision_record.to_organization_id, organization_id)
2939: AND revision = x_item_revision_record.item_revision;
2940:

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:

Line 3173: try to pick up latest revision from mtl_item_revisions

3169:
3170: if revision is still null and
3171: there are any destination_type=INVENTORY then
3172:
3173: try to pick up latest revision from mtl_item_revisions
3174:
3175: end if
3176: else
3177: item should not have any revisions which we will validate in the validation phase */