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.GMO_VBATCH_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1180: select a.material_detail_id, a.formulaline_id, a.inventory_item_id, b.concatenated_segments from gme_material_details a, mtl_system_items_kfv b

1176: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1177: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1178:
1179: cursor c_get_materials is
1180: select a.material_detail_id, a.formulaline_id, a.inventory_item_id, b.concatenated_segments from gme_material_details a, mtl_system_items_kfv b
1181: where a.organization_id = b.organization_id
1182: and a.inventory_item_id = b.inventory_item_id
1183: and a.batch_id = p_entity_key;
1184:

Line 2878: from gme_material_details a, gme_batch_step_items b, MTL_SYSTEM_ITEMS_KFV e

2874: gme_batch_step_resources where batchstep_id=P_BATCHSTEP_ID and batch_id =
2875: P_BATCH_ID and batchstep_activity_id = l_batchstep_activity_id;
2876:
2877: cursor c_get_material is select e.Concatenated_segments, a.material_detail_id
2878: from gme_material_details a, gme_batch_step_items b, MTL_SYSTEM_ITEMS_KFV e
2879: where a.material_detail_id = b.material_detail_id
2880: and (a.inventory_item_id = e.inventory_item_id and a.organization_id =
2881: e.organization_id)
2882: and b.batchstep_id = P_BATCHSTEP_ID and a.batch_id = P_BATCH_ID;