DBA Data[Home] [Help]

APPS.CS_STD dependencies on MTL_ITEM_REVISIONS

Line 261: l_rev_desc mtl_item_revisions.description%type;

257: p_inv_item_id number,
258: p_revision varchar2,
259: p_error_flag varchar2 default 'TRUE'
260: ) return varchar2 is
261: l_rev_desc mtl_item_revisions.description%type;
262: begin
263: if p_org_id is null or
264: p_inv_item_id is null or
265: p_revision is null then

Line 271: from mtl_item_revisions

267: end if;
268: --
269: select description
270: into l_rev_desc
271: from mtl_item_revisions
272: where organization_id = p_org_id
273: and inventory_item_id = p_inv_item_id
274: and revision = p_revision;
275: --