VIEW: APPS.IGS_AD_SOURCE_CAT_V

Source

View Text - Preformatted

SELECT SC.ROW_ID ROW_ID, SC.SRC_CAT_ID SRC_CAT_ID, SC.CATEGORY_NAME CATEGORY_NAME, LK2.MEANING CATEGORY_NAME_MEANING, SC.MANDATORY_IND MANDATORY_IND, SC.SS_MANDATORY_IND SS_MANDATORY_IND, LK1.MEANING DISCREPANCY_RULE, SC.DISCREPANCY_RULE_CD DISCREPANCY_RULE_CD, SC.SOURCE_TYPE_ID SOURCE_TYPE_ID, SC.INCLUDE_IND INCLUDE_IND, SC.SS_IND ss_ind, SC.DISPLAY_SEQUENCE display_sequence, SC.DETAIL_LEVEL_IND DETAIL_LEVEL_IND, SC.AD_TAB_NAME AD_TAB_NAME, SC.INT_TAB_NAME INT_TAB_NAME, SC.CREATED_BY CREATED_BY, SC.CREATION_DATE CREATION_DATE, SC.LAST_UPDATED_BY LAST_UPDATED_BY, SC.LAST_UPDATE_DATE LAST_UPDATE_DATE, SC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_SOURCE_CAT SC, IGS_LOOKUPS_VIEW LK1, IGS_LOOKUPS_VIEW LK2 WHERE LK1.LOOKUP_CODE = SC.DISCREPANCY_RULE_CD AND LK1.LOOKUP_TYPE = 'DISCREPANCY_RULE' AND LK2.LOOKUP_TYPE = 'IMP_CATEGORIES' AND LK2.LOOKUP_CODE = SC.CATEGORY_NAME AND LK2.ENABLED_FLAG = 'Y'

View Text - HTML Formatted

SELECT SC.ROW_ID ROW_ID
, SC.SRC_CAT_ID SRC_CAT_ID
, SC.CATEGORY_NAME CATEGORY_NAME
, LK2.MEANING CATEGORY_NAME_MEANING
, SC.MANDATORY_IND MANDATORY_IND
, SC.SS_MANDATORY_IND SS_MANDATORY_IND
, LK1.MEANING DISCREPANCY_RULE
, SC.DISCREPANCY_RULE_CD DISCREPANCY_RULE_CD
, SC.SOURCE_TYPE_ID SOURCE_TYPE_ID
, SC.INCLUDE_IND INCLUDE_IND
, SC.SS_IND SS_IND
, SC.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, SC.DETAIL_LEVEL_IND DETAIL_LEVEL_IND
, SC.AD_TAB_NAME AD_TAB_NAME
, SC.INT_TAB_NAME INT_TAB_NAME
, SC.CREATED_BY CREATED_BY
, SC.CREATION_DATE CREATION_DATE
, SC.LAST_UPDATED_BY LAST_UPDATED_BY
, SC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SOURCE_CAT SC
, IGS_LOOKUPS_VIEW LK1
, IGS_LOOKUPS_VIEW LK2
WHERE LK1.LOOKUP_CODE = SC.DISCREPANCY_RULE_CD
AND LK1.LOOKUP_TYPE = 'DISCREPANCY_RULE'
AND LK2.LOOKUP_TYPE = 'IMP_CATEGORIES'
AND LK2.LOOKUP_CODE = SC.CATEGORY_NAME
AND LK2.ENABLED_FLAG = 'Y'