DBA Data[Home] [Help]

APPS.CS_STD dependencies on MTL_ITEM_REVISIONS

Line 260: l_rev_desc mtl_item_revisions.description%type;

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

Line 270: from mtl_item_revisions

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