DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_ITEM_REVISIONS

Line 3076: FROM mtl_item_revisions

3072: END IF;
3073:
3074: SELECT NVL(MAX(inventory_item_id), 0)
3075: INTO x_inventory_item
3076: FROM mtl_item_revisions
3077: WHERE inventory_item_id = x_item_revision_record.item_id
3078: AND organization_id = NVL(x_item_revision_record.to_organization_id, organization_id)
3079: AND revision = x_item_revision_record.item_revision;
3080:

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

3086: -- Check whether revision is still active
3087:
3088: SELECT NVL(MAX(inventory_item_id), 0) -- does this accurately check for active revisions??
3089: INTO x_inventory_item
3090: FROM MTL_ITEM_REVISIONS_B mir --Bug 5217526. Earlier using mtl_item_revisions_org_val_v
3091: WHERE mir.inventory_item_id = x_item_revision_record.item_id
3092: AND mir.organization_id = NVL(x_item_revision_record.to_organization_id, mir.organization_id)
3093: AND mir.revision = x_item_revision_record.item_revision;
3094:

Line 3313: try to pick up latest revision from mtl_item_revisions

3309:
3310: if revision is still null and
3311: there are any destination_type=INVENTORY then
3312:
3313: try to pick up latest revision from mtl_item_revisions
3314:
3315: end if
3316: else
3317: item should not have any revisions which we will validate in the validation phase */