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_HEADER

Line 61: l_batch_id gme_batch_header.batch_id%TYPE;

57: l_label_status VARCHAR2(1);
58: l_label_err_msg VARCHAR2(1000);
59: l_is_epc_exist VARCHAR2(1) := 'N';
60:
61: l_batch_id gme_batch_header.batch_id%TYPE;
62: l_batch_no gme_batch_header.batch_no%TYPE;
63:
64: l_organization mtl_parameters.organization_code%TYPE;
65:

Line 62: l_batch_no gme_batch_header.batch_no%TYPE;

58: l_label_err_msg VARCHAR2(1000);
59: l_is_epc_exist VARCHAR2(1) := 'N';
60:
61: l_batch_id gme_batch_header.batch_id%TYPE;
62: l_batch_no gme_batch_header.batch_no%TYPE;
63:
64: l_organization mtl_parameters.organization_code%TYPE;
65:
66: l_item mtl_system_items_vl.concatenated_segments%TYPE;

Line 187: gmo_material_dispenses d, gme_batch_header bh,

183: d.lot_number,
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

Line 234: gmo_material_dispenses d, gme_batch_header bh,

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