APPS.GMD_SPEC_GRP dependencies on MTL_ITEM_REVISIONS

Line 104: FROM mtl_item_revisions

100: AND organization_id = p_organization_id;
101:
102: CURSOR c_revision(p_inventory_item_id NUMBER, p_organization_id NUMBER,p_revision VARCHAR2) IS
103: SELECT 1
104: FROM mtl_item_revisions
105: WHERE inventory_item_id = p_inventory_item_id
106: AND organization_id = p_organization_id
107: AND revision = p_revision;
108: --RLNAGARA Bug # 4548546 For Revision

Line 203: -- Check that Revision exist in MTL_ITEM_REVISIONS

199: --Check whether it is a revision controlled item in MTL_SYSTEM_ITEMS_B
200: OPEN c_rev_ctrl(p_spec_header.inventory_item_id, p_spec_header.owner_organization_id);
201: FETCH c_rev_ctrl into dummy;
202: IF dummy = 2 THEN --The item is a revision controlled item
203: -- Check that Revision exist in MTL_ITEM_REVISIONS
204: OPEN c_revision(p_spec_header.inventory_item_id, p_spec_header.owner_organization_id,p_spec_header.revision);
205: FETCH c_revision INTO dummy;
206: IF c_revision%NOTFOUND THEN
207: CLOSE c_revision;