APPS.INV_LABEL_PVT13 dependencies on MTL_TRANSACTION_REASONS

Line 96: l_reason_name mtl_transaction_reasons.reason_name%TYPE;

92: l_subinventory VARCHAR2(30) := NULL;
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:

Line 228: mtl_transaction_reasons mtr,

224: mtl_system_items_vl msi,
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

Line 293: mtl_transaction_reasons mtr

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
297: bl.material_detail_id = gppl.material_detail_id and