VIEW: APPS.CST_PAC_PERIODS_V

Source

View Text - Preformatted

SELECT cpp.rowid row_id, 'PAC_PERIOD' rec_type, cpp.legal_entity legal_entity, cpp.cost_type_id cost_type_id, cpp.pac_period_id pac_period_id, NULL period_type, cpp.period_set_name period_set_name, ml.lookup_code status_code, ml.meaning status, cpp.period_name period_name, cpp.period_num period_num, cpp.period_year period_year, cpp.period_start_date start_date, cpp.period_end_date end_date, cpp.period_close_date close_date, cpp.last_update_date last_update_date, cpp.last_updated_by last_updated_by, cpp.creation_date creation_date, cpp.created_by created_by, cpp.last_update_login last_update_login FROM cst_pac_periods cpp, mfg_lookups ml WHERE ml.LOOKUP_TYPE(+) = 'CST_PAC_PERIOD_STATUS' AND ml.ENABLED_FLAG(+) = 'Y' AND ml.LOOKUP_CODE(+) = DECODE(NVL(cpp.period_close_date,sysdate), cpp.PERIOD_CLOSE_DATE, DECODE(cpp.OPEN_FLAG, 'N', 4, 'Y', 3, 'P', 1, 3), 2 ) UNION SELECT gp.rowid row_id, 'GL_PERIOD' rec_type, 0 legal_entity, 0 cost_type_id, 0 pac_period_id, gp.period_type period_type, gp.period_set_name period_set_name, ml.lookup_code status_code, ml.meaning status, gp.period_name period_name, gp.period_num period_number, gp.period_year period_year, gp.start_date start_date, gp.end_date end_date, to_date(null) close_date, gp.last_update_date last_update_date, gp.last_updated_by last_updated_by, gp.creation_date creation_date, gp.created_by created_by, gp.last_update_login last_update_login FROM gl_periods GP, mfg_lookups ML WHERE ( gp.ADJUSTMENT_PERIOD_FLAG = 'N') AND ml.LOOKUP_TYPE(+) = 'CST_PAC_PERIOD_STATUS' AND ml.ENABLED_FLAG(+) = 'Y' AND ml.LOOKUP_CODE (+) = 5

View Text - HTML Formatted

SELECT CPP.ROWID ROW_ID
, 'PAC_PERIOD' REC_TYPE
, CPP.LEGAL_ENTITY LEGAL_ENTITY
, CPP.COST_TYPE_ID COST_TYPE_ID
, CPP.PAC_PERIOD_ID PAC_PERIOD_ID
, NULL PERIOD_TYPE
, CPP.PERIOD_SET_NAME PERIOD_SET_NAME
, ML.LOOKUP_CODE STATUS_CODE
, ML.MEANING STATUS
, CPP.PERIOD_NAME PERIOD_NAME
, CPP.PERIOD_NUM PERIOD_NUM
, CPP.PERIOD_YEAR PERIOD_YEAR
, CPP.PERIOD_START_DATE START_DATE
, CPP.PERIOD_END_DATE END_DATE
, CPP.PERIOD_CLOSE_DATE CLOSE_DATE
, CPP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CPP.LAST_UPDATED_BY LAST_UPDATED_BY
, CPP.CREATION_DATE CREATION_DATE
, CPP.CREATED_BY CREATED_BY
, CPP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM CST_PAC_PERIODS CPP
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE(+) = 'CST_PAC_PERIOD_STATUS'
AND ML.ENABLED_FLAG(+) = 'Y'
AND ML.LOOKUP_CODE(+) = DECODE(NVL(CPP.PERIOD_CLOSE_DATE
, SYSDATE)
, CPP.PERIOD_CLOSE_DATE
, DECODE(CPP.OPEN_FLAG
, 'N'
, 4
, 'Y'
, 3
, 'P'
, 1
, 3)
, 2 ) UNION SELECT GP.ROWID ROW_ID
, 'GL_PERIOD' REC_TYPE
, 0 LEGAL_ENTITY
, 0 COST_TYPE_ID
, 0 PAC_PERIOD_ID
, GP.PERIOD_TYPE PERIOD_TYPE
, GP.PERIOD_SET_NAME PERIOD_SET_NAME
, ML.LOOKUP_CODE STATUS_CODE
, ML.MEANING STATUS
, GP.PERIOD_NAME PERIOD_NAME
, GP.PERIOD_NUM PERIOD_NUMBER
, GP.PERIOD_YEAR PERIOD_YEAR
, GP.START_DATE START_DATE
, GP.END_DATE END_DATE
, TO_DATE(NULL) CLOSE_DATE
, GP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GP.LAST_UPDATED_BY LAST_UPDATED_BY
, GP.CREATION_DATE CREATION_DATE
, GP.CREATED_BY CREATED_BY
, GP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM GL_PERIODS GP
, MFG_LOOKUPS ML
WHERE ( GP.ADJUSTMENT_PERIOD_FLAG = 'N')
AND ML.LOOKUP_TYPE(+) = 'CST_PAC_PERIOD_STATUS'
AND ML.ENABLED_FLAG(+) = 'Y'
AND ML.LOOKUP_CODE (+) = 5