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 98: FROM mtl_system_items_b

94:
95: --RLNAGARA Bug # 4548546 For Revision
96: CURSOR c_rev_ctrl(p_inventory_item_id NUMBER, p_organization_id NUMBER) IS
97: SELECT revision_qty_control_code
98: FROM mtl_system_items_b
99: WHERE inventory_item_id = p_inventory_item_id
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

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

195:
196: -- Start RLNAGARA Bug # 4548546
197: --For Revision
198: IF (p_spec_header.revision IS NOT NULL) THEN
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