429: l_reason := NULL;
430: ELSE
431: SELECT mtr.reason_name
432: INTO l_reason
433: FROM mtl_transaction_reasons mtr
434: WHERE mtr.reason_id = i_reason;
435: END IF;
436: -- select the operating unit code for which the program is launched.
437:
803: cwod.write_off_transaction_id write_off_trans_id,
804: mp.organization_code org
805: FROM cst_write_offs cwo,
806: po_vendors pov,
807: mtl_transaction_reasons mtr,
808: po_headers_all poh,
809: po_lines_all pol,
810: po_releases_all por,
811: po_line_locations_all poll,