eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 83: FROM mtl_system_items_b

79:
80: --RLNAGARA Bug # 4548546 For Revision
81: CURSOR c_rev_ctrl(p_inventory_item_id NUMBER, p_organization_id NUMBER) IS
82: SELECT revision_qty_control_code
83: FROM mtl_system_items_b
84: WHERE inventory_item_id = p_inventory_item_id
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

Line 184: --Check whether it is a revision controlled item in MTL_SYSTEM_ITEMS_B

180:
181: -- Start RLNAGARA Bug # 4548546
182: --For Revision
183: IF (p_spec_header.revision IS NOT NULL) THEN
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