APPS.INV_LABEL_PVT13 dependencies on PO_HAZARD_CLASSES

Line 97: l_hazard_class po_hazard_classes.hazard_class%TYPE;

93: l_locator_id NUMBER;
94: l_reason_id NUMBER;
95: l_uom2 VARCHAR2(3);
96: l_reason_name mtl_transaction_reasons.reason_name%TYPE;
97: l_hazard_class po_hazard_classes.hazard_class%TYPE;
98: l_locator mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
99: l_count NUMBER;
100:
101: l_parent_lot_number VARCHAR2(80);

Line 229: po_hazard_classes hzc

225: mtl_material_transactions mmt,
226: mtl_transaction_lot_numbers mtln,
227: mtl_item_locations_kfv milk,
228: mtl_transaction_reasons mtr,
229: po_hazard_classes hzc
230: where mmt.transaction_id = p_transaction_id and -- 12409734 and --
231: bh.batch_id = mmt.TRANSACTION_SOURCE_ID AND -- 121706
232: bl.material_detail_id = mmt.TRX_SOURCE_LINE_ID and
233: mmt.organization_id = mp.organization_id AND

Line 292: po_hazard_classes hzc,

288: mtl_parameters mp,
289: gme_material_details bl,
290: mtl_system_items_vl msi,
291: gme_pending_product_lots gppl,
292: po_hazard_classes hzc,
293: mtl_transaction_reasons mtr
294:
295: where gppl.PENDING_PRODUCT_LOT_ID= p_transaction_id and -- 12409734 and --
296: bh.batch_id = gppl.batch_id AND -- 121706