VIEW: APPS.IGS_AD_PRCS_CAT_STEP_V

Source

View Text - Preformatted

SELECT APCS.ROW_ID ROW_ID, APCS.ADMISSION_CAT ADMISSION_CAT, APCS.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE, APCS.S_ADMISSION_STEP_TYPE S_ADMISSION_STEP_TYPE, NULL S_TRACKING_TYPE , NULL S_TRK_MEANING, NULL DESCRIPTION , LKUPV1.MEANING MEANING, APCS.STEP_GROUP_TYPE STEP_GROUP_TYPE, LKUPV1.STEP_TYPE_RESTRICTION_NUM_IND STEP_TYPE_RESTRICTION_NUM_IND, LKUPV1.CLOSED_IND CLOSED_IND, APCS.MANDATORY_STEP_IND MANDATORY_STEP_IND, APCS.STEP_TYPE_RESTRICTION_NUM STEP_TYPE_RESTRICTION_NUM, APCS.STEP_ORDER_NUM STEP_ORDER_NUM, APCS.CREATED_BY CREATED_BY, APCS.CREATION_DATE CREATION_DATE, APCS.LAST_UPDATED_BY LAST_UPDATED_BY, APCS.LAST_UPDATE_DATE LAST_UPDATE_DATE, APCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_PRCS_CAT_STEP APCS, IGS_LOOKUPS_VIEW LKUPV1 WHERE LKUPV1.LOOKUP_TYPE = 'ADMISSION_STEP_TYPE' AND APCS.S_ADMISSION_STEP_TYPE = LKUPV1.LOOKUP_CODE AND APCS.STEP_GROUP_TYPE = LKUPV1.STEP_GROUP_TYPE AND APCS.STEP_GROUP_TYPE <> 'TRACK' UNION SELECT APCS.ROW_ID ROW_ID, APCS.ADMISSION_CAT ADMISSION_CAT, APCS.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE, APCS.S_ADMISSION_STEP_TYPE S_ADMISSION_STEP_TYPE, TRT.S_TRACKING_TYPE S_TRACKING_TYPE , LKUPV2.MEANING S_TRK_MEANING, TRT.DESCRIPTION DESCRIPTION , NULL MEANING, 'TRACK' STEP_GROUP_TYPE, 'N' STEP_TYPE_RESTRICTION_NUM_IND, TRT.CLOSED_IND CLOSED_IND, APCS.MANDATORY_STEP_IND MANDATORY_STEP_IND, APCS.STEP_TYPE_RESTRICTION_NUM STEP_TYPE_RESTRICTION_NUM, APCS.STEP_ORDER_NUM STEP_ORDER_NUM, APCS.CREATED_BY CREATED_BY, APCS.CREATION_DATE CREATION_DATE, APCS.LAST_UPDATED_BY LAST_UPDATED_BY, APCS.LAST_UPDATE_DATE LAST_UPDATE_DATE, APCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_PRCS_CAT_STEP APCS, IGS_TR_TYPE TRT, IGS_LOOKUP_VALUES LKUPV2 WHERE APCS.S_ADMISSION_STEP_TYPE = TRT.TRACKING_TYPE AND TRT.S_TRACKING_TYPE = LKUPV2.LOOKUP_CODE AND LKUPV2.LOOKUP_TYPE = 'TRACKING_TYPE' AND APCS.STEP_GROUP_TYPE = 'TRACK'

View Text - HTML Formatted

SELECT APCS.ROW_ID ROW_ID
, APCS.ADMISSION_CAT ADMISSION_CAT
, APCS.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, APCS.S_ADMISSION_STEP_TYPE S_ADMISSION_STEP_TYPE
, NULL S_TRACKING_TYPE
, NULL S_TRK_MEANING
, NULL DESCRIPTION
, LKUPV1.MEANING MEANING
, APCS.STEP_GROUP_TYPE STEP_GROUP_TYPE
, LKUPV1.STEP_TYPE_RESTRICTION_NUM_IND STEP_TYPE_RESTRICTION_NUM_IND
, LKUPV1.CLOSED_IND CLOSED_IND
, APCS.MANDATORY_STEP_IND MANDATORY_STEP_IND
, APCS.STEP_TYPE_RESTRICTION_NUM STEP_TYPE_RESTRICTION_NUM
, APCS.STEP_ORDER_NUM STEP_ORDER_NUM
, APCS.CREATED_BY CREATED_BY
, APCS.CREATION_DATE CREATION_DATE
, APCS.LAST_UPDATED_BY LAST_UPDATED_BY
, APCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PRCS_CAT_STEP APCS
, IGS_LOOKUPS_VIEW LKUPV1
WHERE LKUPV1.LOOKUP_TYPE = 'ADMISSION_STEP_TYPE'
AND APCS.S_ADMISSION_STEP_TYPE = LKUPV1.LOOKUP_CODE
AND APCS.STEP_GROUP_TYPE = LKUPV1.STEP_GROUP_TYPE
AND APCS.STEP_GROUP_TYPE <> 'TRACK' UNION SELECT APCS.ROW_ID ROW_ID
, APCS.ADMISSION_CAT ADMISSION_CAT
, APCS.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, APCS.S_ADMISSION_STEP_TYPE S_ADMISSION_STEP_TYPE
, TRT.S_TRACKING_TYPE S_TRACKING_TYPE
, LKUPV2.MEANING S_TRK_MEANING
, TRT.DESCRIPTION DESCRIPTION
, NULL MEANING
, 'TRACK' STEP_GROUP_TYPE
, 'N' STEP_TYPE_RESTRICTION_NUM_IND
, TRT.CLOSED_IND CLOSED_IND
, APCS.MANDATORY_STEP_IND MANDATORY_STEP_IND
, APCS.STEP_TYPE_RESTRICTION_NUM STEP_TYPE_RESTRICTION_NUM
, APCS.STEP_ORDER_NUM STEP_ORDER_NUM
, APCS.CREATED_BY CREATED_BY
, APCS.CREATION_DATE CREATION_DATE
, APCS.LAST_UPDATED_BY LAST_UPDATED_BY
, APCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PRCS_CAT_STEP APCS
, IGS_TR_TYPE TRT
, IGS_LOOKUP_VALUES LKUPV2
WHERE APCS.S_ADMISSION_STEP_TYPE = TRT.TRACKING_TYPE
AND TRT.S_TRACKING_TYPE = LKUPV2.LOOKUP_CODE
AND LKUPV2.LOOKUP_TYPE = 'TRACKING_TYPE'
AND APCS.STEP_GROUP_TYPE = 'TRACK'