APPS.INV_LABEL_PVT13 dependencies on PO_HAZARD_CLASSES

Line 100: l_hazard_class po_hazard_classes.hazard_class%TYPE;

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

Line 237: po_hazard_classes hzc

233: mtl_material_transactions mmt,
234: mtl_transaction_lot_numbers mtln,
235: mtl_item_locations_kfv milk,
236: mtl_transaction_reasons mtr,
237: po_hazard_classes hzc
238: where mmt.transaction_id = p_transaction_id and -- 12409734 and --
239: bh.batch_id = mmt.TRANSACTION_SOURCE_ID AND -- 121706
240: bl.material_detail_id = mmt.TRX_SOURCE_LINE_ID and
241: mmt.organization_id = mp.organization_id AND

Line 301: po_hazard_classes hzc,

297: mtl_parameters mp,
298: gme_material_details bl,
299: mtl_system_items_vl msi,
300: gme_pending_product_lots gppl,
301: po_hazard_classes hzc,
302: mtl_transaction_reasons mtr
303:
304: where gppl.PENDING_PRODUCT_LOT_ID= p_transaction_id and -- 12409734 and --
305: bh.batch_id = gppl.batch_id AND -- 121706