APPS.INV_LABEL_PVT11 dependencies on MTL_PARAMETERS

Line 64: l_organization mtl_parameters.organization_code%TYPE;

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;
67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;
68: l_target_container_item mtl_system_items_vl.concatenated_segments%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