SELECT LOOKUP_CODE , MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE = DECODE(MRP_LAUNCH_PLAN_PK.GET_CRP_STATUS(704,705), 'I', LOOKUP_CODE, 2)
View Text - HTML Formatted
SELECT LOOKUP_CODE , MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE = DECODE(MRP_LAUNCH_PLAN_PK.GET_CRP_STATUS(704 , 705) , 'I' , LOOKUP_CODE , 2)