VIEW: DDR.DDR_E_ORG_HCHY#

Source

View Text - Preformatted

select REC_ID REC_ID, ORG_CD ORG_CD, CHAIN_CD CHAIN_CD, CHAIN_GLBL_LOC_ID CHAIN_GLBL_LOC_ID, CHAIN_GLBL_LOC_ID_TYP CHAIN_GLBL_LOC_ID_TYP, CHAIN_NAME CHAIN_NAME, CHAIN_MGR_NAME CHAIN_MGR_NAME, AREA_CD AREA_CD, AREA_GLBL_LOC_ID AREA_GLBL_LOC_ID, AREA_GLBL_LOC_ID_TYP AREA_GLBL_LOC_ID_TYP, AREA_NAME AREA_NAME, AREA_MGR_NAME AREA_MGR_NAME, RGN_CD RGN_CD, RGN_GLBL_LOC_ID RGN_GLBL_LOC_ID, RGN_GLBL_LOC_ID_TYP RGN_GLBL_LOC_ID_TYP, RGN_NAME RGN_NAME, RGN_MGR_NAME RGN_MGR_NAME, DSTRCT_CD DSTRCT_CD, DSTRCT_GLBL_LOC_ID DSTRCT_GLBL_LOC_ID, DSTRCT_GLBL_LOC_ID_TYP DSTRCT_GLBL_LOC_ID_TYP, DSTRCT_NAME DSTRCT_NAME, DSTRCT_MGR_NAME DSTRCT_MGR_NAME, BSNS_UNIT_CD BSNS_UNIT_CD, BSNS_UNIT_GLBL_LOC_ID BSNS_UNIT_GLBL_LOC_ID, BSNS_UNIT_GLBL_LOC_ID_TYP BSNS_UNIT_GLBL_LOC_ID_TYP, BSNS_UNIT_NAME BSNS_UNIT_NAME, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, ERR_REASON ERR_REASON, ACTION_FLAG ACTION_FLAG, LOAD_ID LOAD_ID from "DDR"."DDR_E_ORG_HCHY"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, ORG_CD ORG_CD
, CHAIN_CD CHAIN_CD
, CHAIN_GLBL_LOC_ID CHAIN_GLBL_LOC_ID
, CHAIN_GLBL_LOC_ID_TYP CHAIN_GLBL_LOC_ID_TYP
, CHAIN_NAME CHAIN_NAME
, CHAIN_MGR_NAME CHAIN_MGR_NAME
, AREA_CD AREA_CD
, AREA_GLBL_LOC_ID AREA_GLBL_LOC_ID
, AREA_GLBL_LOC_ID_TYP AREA_GLBL_LOC_ID_TYP
, AREA_NAME AREA_NAME
, AREA_MGR_NAME AREA_MGR_NAME
, RGN_CD RGN_CD
, RGN_GLBL_LOC_ID RGN_GLBL_LOC_ID
, RGN_GLBL_LOC_ID_TYP RGN_GLBL_LOC_ID_TYP
, RGN_NAME RGN_NAME
, RGN_MGR_NAME RGN_MGR_NAME
, DSTRCT_CD DSTRCT_CD
, DSTRCT_GLBL_LOC_ID DSTRCT_GLBL_LOC_ID
, DSTRCT_GLBL_LOC_ID_TYP DSTRCT_GLBL_LOC_ID_TYP
, DSTRCT_NAME DSTRCT_NAME
, DSTRCT_MGR_NAME DSTRCT_MGR_NAME
, BSNS_UNIT_CD BSNS_UNIT_CD
, BSNS_UNIT_GLBL_LOC_ID BSNS_UNIT_GLBL_LOC_ID
, BSNS_UNIT_GLBL_LOC_ID_TYP BSNS_UNIT_GLBL_LOC_ID_TYP
, BSNS_UNIT_NAME BSNS_UNIT_NAME
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, ERR_REASON ERR_REASON
, ACTION_FLAG ACTION_FLAG
, LOAD_ID LOAD_ID
FROM "DDR"."DDR_E_ORG_HCHY"