VIEW: APPS.DDR_R_MKT_AREA_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD, MKT_AREA_ID, MKT_AREA_CD, MKT_AREA_NAME, MKT_AREA_DESC, DEFN_TYP, PRMRY_ZIP_CD, SCNDRY_ZIP_CD, AREA_SHAPE, AREA_TYP, MKT_AREA_UOM_CD, CITY, STATE, CNTRY, TOT_POPLTN, STATE_POPLTN, STATE_SLS, MKT_AREA_TYP, RANKING FROM DDR_R_MKT_AREA UNION SELECT '-1', -1, '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', '-1', -1, -1, -1, '-1', -1 FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, MKT_AREA_ID
, MKT_AREA_CD
, MKT_AREA_NAME
, MKT_AREA_DESC
, DEFN_TYP
, PRMRY_ZIP_CD
, SCNDRY_ZIP_CD
, AREA_SHAPE
, AREA_TYP
, MKT_AREA_UOM_CD
, CITY
, STATE
, CNTRY
, TOT_POPLTN
, STATE_POPLTN
, STATE_SLS
, MKT_AREA_TYP
, RANKING
FROM DDR_R_MKT_AREA UNION SELECT '-1'
, -1
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, -1
, -1
, -1
, '-1'
, -1
FROM DUAL