APPS.ENG_VAL_TO_ID dependencies on MTL_ITEM_REVISIONS

Line 849: FROM MTL_ITEM_REVISIONS

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

Line 1379: from mtl_item_revisions

1375: l_id NUMBER;
1376: ret_code NUMBER;
1377: BEGIN
1378: select revision_id into l_id
1379: from mtl_item_revisions
1380: where inventory_item_id = p_revised_item_num
1381: and organization_id = p_organization_id
1382: and revision = p_revison_code ;
1383:

Line 1722: FROM MTL_ITEM_REVISIONS

1718: l_cur_rev_ef_date DATE;
1719:
1720: CURSOR FROM_REVISION_ID_CURRENT IS
1721: SELECT REVISION_ID, REVISION, EFFECTIVITY_DATE
1722: FROM MTL_ITEM_REVISIONS
1723: WHERE INVENTORY_ITEM_ID = p_assembly_item_id
1724: AND ORGANIZATION_ID = p_organization_id
1725: AND EFFECTIVITY_DATE <= p_revision_date
1726: AND IMPLEMENTATION_DATE IS NOT NULL

Line 1731: FROM MTL_ITEM_REVISIONS

1727: ORDER BY EFFECTIVITY_DATE DESC, REVISION DESC;
1728:
1729: CURSOR FROM_REVISION_ID_FUTURE(p_date IN DATE) IS
1730: SELECT REVISION_ID
1731: FROM MTL_ITEM_REVISIONS
1732: WHERE INVENTORY_ITEM_ID = p_assembly_item_id
1733: AND ORGANIZATION_ID = p_organization_id
1734: AND REVISION = p_revision
1735: AND EFFECTIVITY_DATE > p_date;

Line 2152: from mtl_item_revisions

2148:
2149: IF (p_revised_item_rec.from_end_item_revision is not null) then
2150:
2151: select revision_id into l_rev_item_unexp_rec.from_end_item_revision_id
2152: from mtl_item_revisions
2153: where inventory_item_id =l_rev_item_unexp_rec.from_end_item_id
2154: and organization_id =l_rev_item_unexp_rec.organization_id;
2155:
2156: select bill_sequence_id into l_bill_seq_id from bom_bill_of_materials