VIEW: APPS.BEN_CSS_RLTD_PER_PER_IN_LER_D

Source

View Text - Preformatted

SELECT CSR.ROWID ROW_ID , CSR.CSS_RLTD_PER_PER_IN_LER_ID , CSR.EFFECTIVE_START_DATE , CSR.EFFECTIVE_END_DATE , CSR.ORDR_TO_PRCS_NUM , LER.NAME , RSLTG_LER.NAME , CSR.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR, FND_USER FUSER ,BEN_LER_F LER ,BEN_LER_F RSLTG_LER WHERE FUSER.USER_ID (+)= CSR .LAST_UPDATED_BY AND LER.LER_ID (+)= CSR .LER_ID and csr.effective_start_date between ler.effective_start_date (+) and ler.effective_end_date (+) AND RSLTG_LER.LER_ID (+)= CSR .RSLTG_LER_ID and csr.effective_start_date between rsltg_ler.effective_start_date (+) and rsltg_ler.effective_end_date (+)

View Text - HTML Formatted

SELECT CSR.ROWID ROW_ID
, CSR.CSS_RLTD_PER_PER_IN_LER_ID
, CSR.EFFECTIVE_START_DATE
, CSR.EFFECTIVE_END_DATE
, CSR.ORDR_TO_PRCS_NUM
, LER.NAME
, RSLTG_LER.NAME
, CSR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR
, FND_USER FUSER
, BEN_LER_F LER
, BEN_LER_F RSLTG_LER
WHERE FUSER.USER_ID (+)= CSR .LAST_UPDATED_BY
AND LER.LER_ID (+)= CSR .LER_ID
AND CSR.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE (+)
AND LER.EFFECTIVE_END_DATE (+)
AND RSLTG_LER.LER_ID (+)= CSR .RSLTG_LER_ID
AND CSR.EFFECTIVE_START_DATE BETWEEN RSLTG_LER.EFFECTIVE_START_DATE (+)
AND RSLTG_LER.EFFECTIVE_END_DATE (+)