APPS.ENG_VAL_TO_ID dependencies on MTL_ITEM_REVISIONS

Line 848: FROM MTL_ITEM_REVISIONS

844: BEGIN
845:
846: SELECT -100
847: INTO l_result
848: FROM MTL_ITEM_REVISIONS
849: WHERE inventory_item_id = p_item_id
850: AND organization_id = p_organization_id
851: AND revision = p_item_revision ;
852:

Line 1373: from mtl_item_revisions

1369: l_id NUMBER;
1370: ret_code NUMBER;
1371: BEGIN
1372: select revision_id into l_id
1373: from mtl_item_revisions
1374: where inventory_item_id = p_revised_item_num
1375: and organization_id = p_organization_id
1376: and revision = p_revison_code ;
1377:

Line 1716: FROM MTL_ITEM_REVISIONS

1712: l_cur_rev_ef_date DATE;
1713:
1714: CURSOR FROM_REVISION_ID_CURRENT IS
1715: SELECT REVISION_ID, REVISION, EFFECTIVITY_DATE
1716: FROM MTL_ITEM_REVISIONS
1717: WHERE INVENTORY_ITEM_ID = p_assembly_item_id
1718: AND ORGANIZATION_ID = p_organization_id
1719: AND EFFECTIVITY_DATE <= p_revision_date
1720: AND IMPLEMENTATION_DATE IS NOT NULL

Line 1725: FROM MTL_ITEM_REVISIONS

1721: ORDER BY EFFECTIVITY_DATE DESC, REVISION DESC;
1722:
1723: CURSOR FROM_REVISION_ID_FUTURE(p_date IN DATE) IS
1724: SELECT REVISION_ID
1725: FROM MTL_ITEM_REVISIONS
1726: WHERE INVENTORY_ITEM_ID = p_assembly_item_id
1727: AND ORGANIZATION_ID = p_organization_id
1728: AND REVISION = p_revision
1729: AND EFFECTIVITY_DATE > p_date;

Line 2146: from mtl_item_revisions

2142:
2143: IF (p_revised_item_rec.from_end_item_revision is not null) then
2144:
2145: select revision_id into l_rev_item_unexp_rec.from_end_item_revision_id
2146: from mtl_item_revisions
2147: where inventory_item_id =l_rev_item_unexp_rec.from_end_item_id
2148: and organization_id =l_rev_item_unexp_rec.organization_id;
2149:
2150: select bill_sequence_id into l_bill_seq_id from bom_bill_of_materials