VIEW: APPS.DDR_R_CITY_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD,STATE_CD,CITY_CD,CITY_NAME,CITY_DESC FROM DDR_R_CITY UNION SELECT '-1','-1','-1','-1','-1' FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, STATE_CD
, CITY_CD
, CITY_NAME
, CITY_DESC
FROM DDR_R_CITY UNION SELECT '-1'
, '-1'
, '-1'
, '-1'
, '-1'
FROM DUAL