DBA Data[Home] [Help]

APPS.INV_LABEL_PVT11 dependencies on PO_HAZARD_CLASSES

Line 111: l_hazard_class po_hazard_classes.hazard_class%TYPE;

107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;
109:
110: l_lot_number gmo_material_dispenses.lot_number%TYPE;
111: l_hazard_class po_hazard_classes.hazard_class%TYPE;
112:
113: /*** undispense ****/
114: l_undispense_id gmo_material_undispenses.undispense_id%TYPE;
115: l_undispense_number gmo_material_undispenses.undispense_number%TYPE;

Line 189: mtl_system_items_vl msi, po_hazard_classes hzc

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
193: d.batch_step_id = bs.batchstep_id(+) AND

Line 235: mtl_system_items_vl msi, po_hazard_classes hzc , gmo_material_undispenses und

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
239: und.organization_id = mp.organization_id AND