APPS.GMD_SPEC_GRP dependencies on MTL_ITEM_REVISIONS

Line 89: FROM mtl_item_revisions

85: AND organization_id = p_organization_id;
86:
87: CURSOR c_revision(p_inventory_item_id NUMBER, p_organization_id NUMBER,p_revision VARCHAR2) IS
88: SELECT 1
89: FROM mtl_item_revisions
90: WHERE inventory_item_id = p_inventory_item_id
91: AND organization_id = p_organization_id
92: AND revision = p_revision;
93: --RLNAGARA Bug # 4548546 For Revision

Line 188: -- Check that Revision exist in MTL_ITEM_REVISIONS

184: --Check whether it is a revision controlled item in MTL_SYSTEM_ITEMS_B
185: OPEN c_rev_ctrl(p_spec_header.inventory_item_id, p_spec_header.owner_organization_id);
186: FETCH c_rev_ctrl into dummy;
187: IF dummy = 2 THEN --The item is a revision controlled item
188: -- Check that Revision exist in MTL_ITEM_REVISIONS
189: OPEN c_revision(p_spec_header.inventory_item_id, p_spec_header.owner_organization_id,p_spec_header.revision);
190: FETCH c_revision INTO dummy;
191: IF c_revision%NOTFOUND THEN
192: CLOSE c_revision;