VIEW: APPS.DDR_R_GEO_RGN_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD,GEO_RGN_ID,RGN_CD,RGN_NAME,RGN_DESC FROM DDR_R_GEO_RGN UNION SELECT '-1',-1,'-1','-1','-1' FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, GEO_RGN_ID
, RGN_CD
, RGN_NAME
, RGN_DESC
FROM DDR_R_GEO_RGN UNION SELECT '-1'
, -1
, '-1'
, '-1'
, '-1'
FROM DUAL