VIEW: APPS.DDR_R_GEO_SUB_RGN_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD,GEO_SUB_RGN_ID,GEO_RGN_ID,RGN_CD,SUB_RGN_CD,SUB_RGN_NAME,SUB_RGN_DESC FROM DDR_R_GEO_SUB_RGN UNION SELECT '-1',-1,-1,'-1','-1','-1','-1' FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, GEO_SUB_RGN_ID
, GEO_RGN_ID
, RGN_CD
, SUB_RGN_CD
, SUB_RGN_NAME
, SUB_RGN_DESC
FROM DDR_R_GEO_SUB_RGN UNION SELECT '-1'
, -1
, -1
, '-1'
, '-1'
, '-1'
, '-1'
FROM DUAL