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.INV_LABEL_PVT11 dependencies on GME_BATCH_STEPS

Line 88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;

84: l_dispense_id gmo_material_dispenses.dispense_id%TYPE;
85: l_dispense_source gmo_material_dispenses.dispense_source%TYPE;
86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;
87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;

Line 188: gme_batch_steps bs, mtl_parameters mp, gmd_operations gop,

184: hzc.hazard_class,
185: d.inventory_item_id
186: from
187: gmo_material_dispenses d, gme_batch_header bh,
188: gme_batch_steps bs, mtl_parameters mp, gmd_operations gop,
189: mtl_system_items_vl msi, po_hazard_classes hzc
190: where d.dispense_id = p_transaction_id AND
191: d.batch_id = bh.batch_id AND
192: d.organization_id = mp.organization_id AND

Line 234: gme_batch_steps bs, mtl_parameters mp, gmd_operations gop,

230: (nvl(und.undispensed_qty,0) + nvl(und.material_loss,0)) undispensed_qty,
231: und.inventory_item_id
232: from
233: gmo_material_dispenses d, gme_batch_header bh,
234: gme_batch_steps bs, mtl_parameters mp, gmd_operations gop,
235: mtl_system_items_vl msi, po_hazard_classes hzc , gmo_material_undispenses und
236: where und.undispense_id = p_transaction_id AND
237: und.dispense_id = d.dispense_id AND
238: und.batch_id = bh.batch_id AND