VIEW: APPS.IGSFV_AS_UNIT_ASS_ITEM_GROUPS

Source

View Text - Preformatted

SELECT UAIG.GROUP_NAME , UAIG.UNIT_CD , UAIG.VERSION_NUMBER , UV.TITLE , UAIG.CAL_TYPE , UAIG.CI_SEQUENCE_NUMBER , CI.DESCRIPTION , '_LA:UAIG.MIDTERM_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING' , UAIG.MIDTERM_FORMULA_QTY , UAIG.MIDTERM_WEIGHT_QTY , '_LA:UAIG.FINAL_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING' , UAIG.FINAL_FORMULA_QTY , UAIG.FINAL_WEIGHT_QTY , UAIG.UNIT_ASS_ITEM_GROUP_ID , UAIG.CREATED_BY , UAIG.CREATION_DATE , UAIG.LAST_UPDATED_BY , UAIG.LAST_UPDATE_DATE FROM IGS_AS_UNIT_AI_GRP UAIG, IGS_PS_UNIT_VER_ALL UV, IGS_CA_INST_ALL CI WHERE UAIG.UNIT_CD = UV.UNIT_CD AND UAIG.VERSION_NUMBER = UV.VERSION_NUMBER AND UAIG.CAL_TYPE = CI.CAL_TYPE AND UAIG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT UAIG.GROUP_NAME
, UAIG.UNIT_CD
, UAIG.VERSION_NUMBER
, UV.TITLE
, UAIG.CAL_TYPE
, UAIG.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, '_LA:UAIG.MIDTERM_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING'
, UAIG.MIDTERM_FORMULA_QTY
, UAIG.MIDTERM_WEIGHT_QTY
, '_LA:UAIG.FINAL_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING'
, UAIG.FINAL_FORMULA_QTY
, UAIG.FINAL_WEIGHT_QTY
, UAIG.UNIT_ASS_ITEM_GROUP_ID
, UAIG.CREATED_BY
, UAIG.CREATION_DATE
, UAIG.LAST_UPDATED_BY
, UAIG.LAST_UPDATE_DATE
FROM IGS_AS_UNIT_AI_GRP UAIG
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI
WHERE UAIG.UNIT_CD = UV.UNIT_CD
AND UAIG.VERSION_NUMBER = UV.VERSION_NUMBER
AND UAIG.CAL_TYPE = CI.CAL_TYPE
AND UAIG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY