DBA Data[Home] [Help]

APPS.BOM_BOM_REVISION_UTIL dependencies on DUAL

Line 113: SELECT userenv('LANG') INTO l_language_code FROM dual;

109: Fnd_Global.Prog_Appl_Id,
110: SYSDATE
111: ) RETURNING revision_id INTO l_revision_id;
112:
113: SELECT userenv('LANG') INTO l_language_code FROM dual;
114:
115: -- Insert into TL table
116:
117: INSERT INTO mtl_item_revisions_TL

Line 219: SELECT userenv('LANG') INTO l_language_code FROM dual;

215: AND organization_id = p_bom_rev_unexp_rec.organization_id
216: RETURNING revision_id INTO l_revision_id;
217: -- Added conditions for bug 1888688.
218:
219: SELECT userenv('LANG') INTO l_language_code FROM dual;
220:
221: -- Update the description in the TL table
222: --
223: UPDATE mtl_item_revisions_TL