VIEW: APPS.IGS_PS_NSUS_RTN_V

Source

View Text - Preformatted

SELECT NR.rowid row_id, NR.non_std_usec_rtn_id, NR.uoo_id, NR.fee_type, fee.description fee_type_desc, NR.definition_code, lv.meaning definition_code_meaning, NR.formula_method, NR.round_method, NR.INCL_WKEND_DURATION_FLAG, NR.created_by, NR.creation_date, NR.last_updated_by, NR.last_update_date, NR.last_update_login FROM IGS_PS_NSUS_RTN NR, IGS_LOOKUP_VALUES lv, IGS_FI_FEE_TYPE_ALL FEE WHERE NR.definition_code = lv.lookup_code AND lv.lookup_type = 'DEFINITION_LEVEL' AND NR.fee_type = fee.fee_type (+)

View Text - HTML Formatted

SELECT NR.ROWID ROW_ID
, NR.NON_STD_USEC_RTN_ID
, NR.UOO_ID
, NR.FEE_TYPE
, FEE.DESCRIPTION FEE_TYPE_DESC
, NR.DEFINITION_CODE
, LV.MEANING DEFINITION_CODE_MEANING
, NR.FORMULA_METHOD
, NR.ROUND_METHOD
, NR.INCL_WKEND_DURATION_FLAG
, NR.CREATED_BY
, NR.CREATION_DATE
, NR.LAST_UPDATED_BY
, NR.LAST_UPDATE_DATE
, NR.LAST_UPDATE_LOGIN
FROM IGS_PS_NSUS_RTN NR
, IGS_LOOKUP_VALUES LV
, IGS_FI_FEE_TYPE_ALL FEE
WHERE NR.DEFINITION_CODE = LV.LOOKUP_CODE
AND LV.LOOKUP_TYPE = 'DEFINITION_LEVEL'
AND NR.FEE_TYPE = FEE.FEE_TYPE (+)