DBA Data[Home] [Help]

VIEW: APPS.MRP_CRP_STATUS_V

Source

View Text - Preformatted

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)