[Home] [Help]
811: IF(p_func_area = 'PO' and p_version = '7.1') THEN
812: IF ((p_viewby = 'HRI_PERSON+HRI_PER')
813: or (p_viewby = 'SUPPLIER+POA_SUPPLIERS') ) THEN
814: return
815: 'select decode(v.value,null,fnd_message.get_string'
816: || '(''POA'', ''POA_DBI_APL_UNASSIGNED''),v.value) VIEWBY,'
817: || fnd_global.newline
818: || ' decode(v.id, null, -1, v.id) VIEWBYID,'
819: || fnd_global.newline;
823: IF(p_func_area = 'PO' and p_version = '8.0') THEN
824: IF ((p_viewby = 'POA_PERSON+NEG_CREATOR')
825: or (p_viewby = 'LOOKUP+NEG_DOCTYPES') ) THEN
826: return
827: 'select decode(v.value,null,fnd_message.get_string'
828: || '(''POA'', ''POA_DBI_APL_UNASSIGNED''),v.value) VIEWBY,'
829: || fnd_global.newline
830: || ' decode(v.id, null, -1, v.id) VIEWBYID,'
831: || fnd_global.newline;
833: end if;
834:
835: if(p_viewby = 'ITEM+POA_COMMODITIES') then
836: return
837: 'select decode(v.name, null, fnd_message.get_string(''POA'',''POA_DBI_APL_UNASSIGNED''), v.name) VIEWBY,
838: decode(v.commodity_id,null, -1, v.commodity_id) VIEWBYID,';
839: elsif(p_viewby = 'LOOKUP+RETURN_REASON') then
840: return
841: 'select decode(v.reason_name, null, fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''), v.reason_name) VIEWBY,
837: 'select decode(v.name, null, fnd_message.get_string(''POA'',''POA_DBI_APL_UNASSIGNED''), v.name) VIEWBY,
838: decode(v.commodity_id,null, -1, v.commodity_id) VIEWBYID,';
839: elsif(p_viewby = 'LOOKUP+RETURN_REASON') then
840: return
841: 'select decode(v.reason_name, null, fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''), v.reason_name) VIEWBY,
842: decode(v.reason_id, null, -1, v.reason_id) VIEWBYID,';
843: else
844: return
845: 'select v.value VIEWBY,v.id VIEWBYID,';
2252: select substr(week_id,3,2) into l_year
2253: from fii_time_week
2254: where l_asof_date between start_date and end_date;
2255:
2256: stmt := fnd_message.get_string('FII', 'FII_AR_WEEK')||' '||l_week||' '||l_year;
2257: end if;
2258: return stmt;
2259: end get_msg;
2260: