VIEW: APPS.BEN_CM_TYP_TRGR_D

Source

View Text - Preformatted

SELECT ctt.ROWID ROW_ID, ctt.CM_TYP_TRGR_ID ,ctt.EFFECTIVE_START_DATE ,ctt.EFFECTIVE_END_DATE ,CM_TYP_TRGR.FORMULA_NAME ,CM_TRGR.DESC_TXT ,CM_TYP.NAME ,ctt.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_CM_TYP_TRGR_F ctt, fnd_user fuser ,BEN_CM_TRGR CM_TRGR ,BEN_CM_TYP_F CM_TYP ,ff_formulas_f CM_TYP_TRGR WHERE fuser.user_id (+)= ctt .last_updated_by and CM_TRGR.CM_TRGR_ID (+)= ctt .CM_TRGR_ID and CM_TYP.CM_TYP_ID (+)= ctt .CM_TYP_ID and CM_TYP_TRGR.formula_id (+)= ctt .CM_TYP_TRGR_RL and ctt .EFFECTIVE_START_DATE BETWEEN CM_TYP_TRGR.EFFECTIVE_START_DATE(+) and CM_TYP_TRGR.EFFECTIVE_END_DATE(+) and ctt .EFFECTIVE_START_DATE BETWEEN CM_TYP.EFFECTIVE_START_DATE(+) and CM_TYP.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT CTT.ROWID ROW_ID
, CTT.CM_TYP_TRGR_ID
, CTT.EFFECTIVE_START_DATE
, CTT.EFFECTIVE_END_DATE
, CM_TYP_TRGR.FORMULA_NAME
, CM_TRGR.DESC_TXT
, CM_TYP.NAME
, CTT.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_CM_TYP_TRGR_F CTT
, FND_USER FUSER
, BEN_CM_TRGR CM_TRGR
, BEN_CM_TYP_F CM_TYP
, FF_FORMULAS_F CM_TYP_TRGR
WHERE FUSER.USER_ID (+)= CTT .LAST_UPDATED_BY
AND CM_TRGR.CM_TRGR_ID (+)= CTT .CM_TRGR_ID
AND CM_TYP.CM_TYP_ID (+)= CTT .CM_TYP_ID
AND CM_TYP_TRGR.FORMULA_ID (+)= CTT .CM_TYP_TRGR_RL
AND CTT .EFFECTIVE_START_DATE BETWEEN CM_TYP_TRGR.EFFECTIVE_START_DATE(+)
AND CM_TYP_TRGR.EFFECTIVE_END_DATE(+)
AND CTT .EFFECTIVE_START_DATE BETWEEN CM_TYP.EFFECTIVE_START_DATE(+)
AND CM_TYP.EFFECTIVE_END_DATE(+)