VIEW: APPS.DDR_R_TIME_HCHY_UNION_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD, BSNS_YR_ID AS HCHY_ID, YR_CD AS HCHY_CD, 'YEAR' AS HCHY_LVL, clndr_cd AS clndr_cd FROM DDR_R_BSNS_YR UNION SELECT MFG_ORG_CD, BSNS_QTR_ID AS HCHY_ID, QTR_CD AS HCHY_CD, 'QUARTER' AS HCHY_LVL, clndr_cd AS clndr_cd FROM DDR_R_BSNS_QTR UNION SELECT MFG_ORG_CD, BSNS_MNTH_ID AS HCHY_ID, MNTH_CD AS HCHY_CD, 'MONTH' AS HCHY_LVL, clndr_cd AS clndr_cd FROM DDR_R_BSNS_MNTH UNION SELECT MFG_ORG_CD, BSNS_WK_ID AS HCHY_ID, WK_CD AS HCHY_CD, 'WEEK' AS HCHY_LVL, clndr_cd AS clndr_cd FROM DDR_R_BSNS_WK UNION SELECT MFG_ORG_CD, BASE_DAY_ID AS HCHY_ID, DAY_CD AS HCHY_CD, 'DAY' AS HCHY_LVL, CLNDR_CD AS CLNDR_CD FROM DDR_R_BASE_DAY WHERE CLNDR_CD = MFG_ORG_CD ||'-BSNS' UNION SELECT '-1' AS MFG_ORG_CD, to_number(DAY_CD) AS HCHY_ID, DAY_CD AS HCHY_CD, 'DAY' AS HCHY_LVL, 'CLNDR' clndr_cd FROM DDR_R_DAY UNION SELECT '-1' AS MFG_ORG_CD, CLNDR_YR_ID AS HCHY_ID, YR_CD AS HCHY_CD, 'YEAR' AS HCHY_LVL, 'CLNDR' AS clndr_cd FROM DDR_R_CLNDR_YR UNION SELECT '-1' MFG_ORG_CD, CLNDR_QTR_ID AS HCHY_ID, QTR_CD AS HCHY_CD, 'QUARTER' AS HCHY_LVL, 'CLNDR' AS clndr_cd FROM DDR_R_CLNDR_QTR UNION SELECT '-1' AS MFG_ORG_CD, CLNDR_MNTH_ID AS HCHY_ID, MNTH_CD AS HCHY_CD, 'MONTH' AS HCHY_LVL, 'CLNDR' AS clndr_cd FROM DDR_R_CLNDR_MNTH UNION SELECT '-1' AS MFG_ORG_CD, CLNDR_WK_ID AS HCHY_ID, WK_CD AS HCHY_CD, 'WEEK' AS HCHY_LVL, 'CLNDR' AS clndr_cd FROM DDR_R_CLNDR_WK UNION SELECT '-1', -1 AS HCHY_ID, '-1' AS HCHY_CD, 'NA' AS HCHY_LVL, 'NA' AS clndr_cd FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, BSNS_YR_ID AS HCHY_ID
, YR_CD AS HCHY_CD
, 'YEAR' AS HCHY_LVL
, CLNDR_CD AS CLNDR_CD
FROM DDR_R_BSNS_YR UNION SELECT MFG_ORG_CD
, BSNS_QTR_ID AS HCHY_ID
, QTR_CD AS HCHY_CD
, 'QUARTER' AS HCHY_LVL
, CLNDR_CD AS CLNDR_CD
FROM DDR_R_BSNS_QTR UNION SELECT MFG_ORG_CD
, BSNS_MNTH_ID AS HCHY_ID
, MNTH_CD AS HCHY_CD
, 'MONTH' AS HCHY_LVL
, CLNDR_CD AS CLNDR_CD
FROM DDR_R_BSNS_MNTH UNION SELECT MFG_ORG_CD
, BSNS_WK_ID AS HCHY_ID
, WK_CD AS HCHY_CD
, 'WEEK' AS HCHY_LVL
, CLNDR_CD AS CLNDR_CD
FROM DDR_R_BSNS_WK UNION SELECT MFG_ORG_CD
, BASE_DAY_ID AS HCHY_ID
, DAY_CD AS HCHY_CD
, 'DAY' AS HCHY_LVL
, CLNDR_CD AS CLNDR_CD
FROM DDR_R_BASE_DAY
WHERE CLNDR_CD = MFG_ORG_CD ||'-BSNS' UNION SELECT '-1' AS MFG_ORG_CD
, TO_NUMBER(DAY_CD) AS HCHY_ID
, DAY_CD AS HCHY_CD
, 'DAY' AS HCHY_LVL
, 'CLNDR' CLNDR_CD
FROM DDR_R_DAY UNION SELECT '-1' AS MFG_ORG_CD
, CLNDR_YR_ID AS HCHY_ID
, YR_CD AS HCHY_CD
, 'YEAR' AS HCHY_LVL
, 'CLNDR' AS CLNDR_CD
FROM DDR_R_CLNDR_YR UNION SELECT '-1' MFG_ORG_CD
, CLNDR_QTR_ID AS HCHY_ID
, QTR_CD AS HCHY_CD
, 'QUARTER' AS HCHY_LVL
, 'CLNDR' AS CLNDR_CD
FROM DDR_R_CLNDR_QTR UNION SELECT '-1' AS MFG_ORG_CD
, CLNDR_MNTH_ID AS HCHY_ID
, MNTH_CD AS HCHY_CD
, 'MONTH' AS HCHY_LVL
, 'CLNDR' AS CLNDR_CD
FROM DDR_R_CLNDR_MNTH UNION SELECT '-1' AS MFG_ORG_CD
, CLNDR_WK_ID AS HCHY_ID
, WK_CD AS HCHY_CD
, 'WEEK' AS HCHY_LVL
, 'CLNDR' AS CLNDR_CD
FROM DDR_R_CLNDR_WK UNION SELECT '-1'
, -1 AS HCHY_ID
, '-1' AS HCHY_CD
, 'NA' AS HCHY_LVL
, 'NA' AS CLNDR_CD
FROM DUAL