DBA Data[Home] [Help]

APPS.INV_OPM_REASON_CODE_MIGRATION dependencies on SY_REAS_CDS_B

Line 42: FROM sy_reas_cds_b b, sy_reas_cds_tl tl,

38: b.creation_date,
39: b.created_by,
40: b.last_updated_by,
41: b.last_update_login
42: FROM sy_reas_cds_b b, sy_reas_cds_tl tl,
43: fnd_languages fl
44: WHERE tl.language = fl.language_code
45: AND fl.installed_flag = 'B'
46: AND b.reason_code = tl.reason_code

Line 89: UPDATE sy_reas_cds_b

85: , l_rec.last_update_login);
86:
87: /* set the reason_id column in sy_reas_cds with this new reason_id */
88:
89: UPDATE sy_reas_cds_b
90: SET reason_id = l_reason_id
91: WHERE reason_code = l_rec.reason_code;
92:
93: EXCEPTION