APPS.INV_OPM_REASON_CODE_MIGRATION dependencies on MTL_TRANSACTION_REASONS

Line 64: (select reason_id from mtl_transaction_reasons b where b.reason_name = a.reason_code);

60: , p_context => 'REASON_CODES');
61:
62: -- bug16067107
63: update sy_reas_cds_b a set a.reason_id =
64: (select reason_id from mtl_transaction_reasons b where b.reason_name = a.reason_code);
65:
66: FOR l_rec IN opm_reas_cds_cur LOOP
67:
68: BEGIN

Line 70: SELECT mtl_transaction_reasons_s.nextval

66: FOR l_rec IN opm_reas_cds_cur LOOP
67:
68: BEGIN
69:
70: SELECT mtl_transaction_reasons_s.nextval
71: INTO l_reason_id FROM DUAL;
72:
73: INSERT INTO mtl_transaction_reasons
74: ( reason_id

Line 73: INSERT INTO mtl_transaction_reasons

69:
70: SELECT mtl_transaction_reasons_s.nextval
71: INTO l_reason_id FROM DUAL;
72:
73: INSERT INTO mtl_transaction_reasons
74: ( reason_id
75: , reason_name
76: , description
77: , disable_date