VIEW: APPS.BEN_CM_TYP_D

Source

View Text - Preformatted

SELECT cct.ROWID ROW_ID, cct.CM_TYP_ID ,cct.EFFECTIVE_START_DATE ,cct.EFFECTIVE_END_DATE ,cct.NAME ,cct.DESC_TXT ,CM_TYP.FORMULA_NAME ,CM_USG.MEANING ,WHNVR_TRGRD.MEANING ,cct.SHRT_NAME ,PC_KIT.MEANING ,TRK_MLG.MEANING ,cct.MX_NUM_AVLBL_VAL ,TO_BE_SENT_DT.MEANING ,TO_BE_SENT_DT_B.FORMULA_NAME ,INSPN_RQD.MEANING ,INSPN_RQD_B.FORMULA_NAME ,RCPENT.MEANING ,PARNT_CM_TYP.NAME ,cct.LAST_UPDATE_DATE ,fuser.user_name LAST_UPDATED_BY from BEN_CM_TYP_F cct, fnd_user fuser ,BEN_CM_TYP_F PARNT_CM_TYP ,hr_lookups CM_USG ,hr_lookups PC_KIT ,hr_lookups TO_BE_SENT_DT ,hr_lookups RCPENT ,hr_lookups WHNVR_TRGRD ,hr_lookups TRK_MLG ,hr_lookups INSPN_RQD ,ff_formulas_f CM_TYP ,ff_formulas_f TO_BE_SENT_DT_B ,ff_formulas_f INSPN_RQD_B WHERE fuser.user_id (+)= cct .last_updated_by and PARNT_CM_TYP.PARNT_CM_TYP_ID (+)= cct .PARNT_CM_TYP_ID and CM_USG.lookup_code (+)= cct .CM_USG_CD and CM_USG.lookup_type (+)= 'BEN_CM_USG' and PC_KIT.lookup_code (+)= cct .PC_KIT_CD and PC_KIT.lookup_type (+)= 'BEN_PC_KIT' and TO_BE_SENT_DT.lookup_code (+)= cct .TO_BE_SENT_DT_CD and TO_BE_SENT_DT.lookup_type (+)= 'BEN_TO_BE_SENT_DT' and RCPENT.lookup_code (+)= cct .RCPENT_CD and RCPENT.lookup_type (+)= 'BEN_RCPENT' and WHNVR_TRGRD.lookup_code (+)= cct .WHNVR_TRGRD_FLAG and WHNVR_TRGRD.lookup_type (+)= 'YES_NO' and TRK_MLG.lookup_code (+)= cct .TRK_MLG_FLAG and TRK_MLG.lookup_type (+)= 'YES_NO' and INSPN_RQD.lookup_code (+)= cct .INSPN_RQD_FLAG and INSPN_RQD.lookup_type (+)= 'YES_NO' and CM_TYP.formula_id (+)= cct .CM_TYP_RL and cct .EFFECTIVE_START_DATE BETWEEN CM_TYP.EFFECTIVE_START_DATE(+) and CM_TYP.EFFECTIVE_END_DATE(+) and TO_BE_SENT_DT_B.formula_id (+)= cct .TO_BE_SENT_DT_RL and cct .EFFECTIVE_START_DATE BETWEEN TO_BE_SENT_DT_B.EFFECTIVE_START_DATE(+) and TO_BE_SENT_DT_B.EFFECTIVE_END_DATE(+) and INSPN_RQD_B.formula_id (+)= cct .INSPN_RQD_RL and cct .EFFECTIVE_START_DATE BETWEEN INSPN_RQD_B.EFFECTIVE_START_DATE(+) and INSPN_RQD_B.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT CCT.ROWID ROW_ID
, CCT.CM_TYP_ID
, CCT.EFFECTIVE_START_DATE
, CCT.EFFECTIVE_END_DATE
, CCT.NAME
, CCT.DESC_TXT
, CM_TYP.FORMULA_NAME
, CM_USG.MEANING
, WHNVR_TRGRD.MEANING
, CCT.SHRT_NAME
, PC_KIT.MEANING
, TRK_MLG.MEANING
, CCT.MX_NUM_AVLBL_VAL
, TO_BE_SENT_DT.MEANING
, TO_BE_SENT_DT_B.FORMULA_NAME
, INSPN_RQD.MEANING
, INSPN_RQD_B.FORMULA_NAME
, RCPENT.MEANING
, PARNT_CM_TYP.NAME
, CCT.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM BEN_CM_TYP_F CCT
, FND_USER FUSER
, BEN_CM_TYP_F PARNT_CM_TYP
, HR_LOOKUPS CM_USG
, HR_LOOKUPS PC_KIT
, HR_LOOKUPS TO_BE_SENT_DT
, HR_LOOKUPS RCPENT
, HR_LOOKUPS WHNVR_TRGRD
, HR_LOOKUPS TRK_MLG
, HR_LOOKUPS INSPN_RQD
, FF_FORMULAS_F CM_TYP
, FF_FORMULAS_F TO_BE_SENT_DT_B
, FF_FORMULAS_F INSPN_RQD_B
WHERE FUSER.USER_ID (+)= CCT .LAST_UPDATED_BY
AND PARNT_CM_TYP.PARNT_CM_TYP_ID (+)= CCT .PARNT_CM_TYP_ID
AND CM_USG.LOOKUP_CODE (+)= CCT .CM_USG_CD
AND CM_USG.LOOKUP_TYPE (+)= 'BEN_CM_USG'
AND PC_KIT.LOOKUP_CODE (+)= CCT .PC_KIT_CD
AND PC_KIT.LOOKUP_TYPE (+)= 'BEN_PC_KIT'
AND TO_BE_SENT_DT.LOOKUP_CODE (+)= CCT .TO_BE_SENT_DT_CD
AND TO_BE_SENT_DT.LOOKUP_TYPE (+)= 'BEN_TO_BE_SENT_DT'
AND RCPENT.LOOKUP_CODE (+)= CCT .RCPENT_CD
AND RCPENT.LOOKUP_TYPE (+)= 'BEN_RCPENT'
AND WHNVR_TRGRD.LOOKUP_CODE (+)= CCT .WHNVR_TRGRD_FLAG
AND WHNVR_TRGRD.LOOKUP_TYPE (+)= 'YES_NO'
AND TRK_MLG.LOOKUP_CODE (+)= CCT .TRK_MLG_FLAG
AND TRK_MLG.LOOKUP_TYPE (+)= 'YES_NO'
AND INSPN_RQD.LOOKUP_CODE (+)= CCT .INSPN_RQD_FLAG
AND INSPN_RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND CM_TYP.FORMULA_ID (+)= CCT .CM_TYP_RL
AND CCT .EFFECTIVE_START_DATE BETWEEN CM_TYP.EFFECTIVE_START_DATE(+)
AND CM_TYP.EFFECTIVE_END_DATE(+)
AND TO_BE_SENT_DT_B.FORMULA_ID (+)= CCT .TO_BE_SENT_DT_RL
AND CCT .EFFECTIVE_START_DATE BETWEEN TO_BE_SENT_DT_B.EFFECTIVE_START_DATE(+)
AND TO_BE_SENT_DT_B.EFFECTIVE_END_DATE(+)
AND INSPN_RQD_B.FORMULA_ID (+)= CCT .INSPN_RQD_RL
AND CCT .EFFECTIVE_START_DATE BETWEEN INSPN_RQD_B.EFFECTIVE_START_DATE(+)
AND INSPN_RQD_B.EFFECTIVE_END_DATE(+)