VIEW: APPS.DDR_R_MFG_VRTY_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD,MFG_VRTY_ID,MFG_VRTY_NBR,VRTY_TYP_CD,MFG_VRTY_DESC,EFF_FROM_DT,EFF_TO_DT FROM DDR_R_MFG_VRTY UNION SELECT '-1',-1,'-1','-1','-1',TO_DATE('01-JAN-1900','DD-MON-YYYY') as EFF_FROM_DT, TO_DATE('01-JAN-2400','DD-MON-YYYY') as EFF_TO_DT FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, MFG_VRTY_ID
, MFG_VRTY_NBR
, VRTY_TYP_CD
, MFG_VRTY_DESC
, EFF_FROM_DT
, EFF_TO_DT
FROM DDR_R_MFG_VRTY UNION SELECT '-1'
, -1
, '-1'
, '-1'
, '-1'
, TO_DATE('01-JAN-1900'
, 'DD-MON-YYYY') AS EFF_FROM_DT
, TO_DATE('01-JAN-2400'
, 'DD-MON-YYYY') AS EFF_TO_DT
FROM DUAL