VIEW: APPS.IGSFV_AS_UNT_SECTION_AI_GROUPS

Source

View Text - Preformatted

SELECT UOO.UNIT_CD , UOO.VERSION_NUMBER , UV.TITLE , UOO.CAL_TYPE , UOO.CI_SEQUENCE_NUMBER , CI.DESCRIPTION , UOO.LOCATION_CD , LOC.DESCRIPTION , UOO.UNIT_CLASS , USAG.GROUP_NAME , '_LA:USAG.MIDTERM_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING' , USAG.MIDTERM_FORMULA_QTY , USAG.MIDTERM_WEIGHT_QTY , '_LA:USAG.FINAL_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING' , USAG.FINAL_FORMULA_QTY , USAG.FINAL_WEIGHT_QTY , USAG.US_ASS_ITEM_GROUP_ID , USAG.UOO_ID , USAG.CREATED_BY , USAG.CREATION_DATE , USAG.LAST_UPDATED_BY , USAG.LAST_UPDATE_DATE FROM IGS_AS_US_AI_GROUP USAG, IGS_PS_UNIT_OFR_OPT_ALL UOO, IGS_PS_UNIT_VER_ALL UV, IGS_CA_INST_ALL CI, IGS_AD_LOCATION_ALL LOC WHERE USAG.UOO_ID = UOO.UOO_ID AND UOO.UNIT_CD = UV.UNIT_CD AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER AND UOO.CAL_TYPE = CI.CAL_TYPE AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND UOO.LOCATION_CD = LOC.LOCATION_CD WITH READ ONLY

View Text - HTML Formatted

SELECT UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UV.TITLE
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO.UNIT_CLASS
, USAG.GROUP_NAME
, '_LA:USAG.MIDTERM_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING'
, USAG.MIDTERM_FORMULA_QTY
, USAG.MIDTERM_WEIGHT_QTY
, '_LA:USAG.FINAL_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING'
, USAG.FINAL_FORMULA_QTY
, USAG.FINAL_WEIGHT_QTY
, USAG.US_ASS_ITEM_GROUP_ID
, USAG.UOO_ID
, USAG.CREATED_BY
, USAG.CREATION_DATE
, USAG.LAST_UPDATED_BY
, USAG.LAST_UPDATE_DATE
FROM IGS_AS_US_AI_GROUP USAG
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI
, IGS_AD_LOCATION_ALL LOC
WHERE USAG.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD WITH READ ONLY