eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_PRTT_REIMBMT_RQST

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_PRTT_REIMBMT_RQST

View Text

SELECT PRC.PRTT_REIMBMT_RQST_ID
, PRC.EFFECTIVE_START_DATE
, PRC.EFFECTIVE_END_DATE
, PRC.INCRD_FROM_DT
, PRC.INCRD_TO_DT
, PRC.EXP_INCURD_DT
, PRC.RQST_NUM
, PRC.RQST_AMT
, PRC.RQST_AMT_UOM
, PRC.RQST_BTCH_NUM
, PRC.PRTT_REIMBMT_RQST_STAT_CD
, PRC.REIMBMT_CTFN_TYP_PRVDD_CD
, PRC.RCRRG_CD
, PRC.SUBMITTER_PERSON_ID
, PRC.RECIPIENT_PERSON_ID
, PRC.PROVIDER_PERSON_ID
, PRC.PROVIDER_SSN_PERSON_ID
, PRC.PL_ID
, PRC.GD_OR_SVC_TYP_ID
, PRC.CONTACT_RELATIONSHIP_ID
, PRC.BUSINESS_GROUP_ID
, PRC.PRTT_ENRT_RSLT_ID
, PRC.COMMENT_ID
, PRC.STAT_RSN_CD
, PRC.PYMT_STAT_CD
, PRC.PYMT_STAT_RSN_CD
, PRC.STAT_OVRDN_FLAG
, PRC.STAT_OVRDN_RSN_CD
, PRC.STAT_PRR_TO_OVRD
, PRC.PYMT_STAT_OVRDN_FLAG
, PRC.PYMT_STAT_OVRDN_RSN_CD
, PRC.PYMT_STAT_PRR_TO_OVRD
, PRC.ADJMT_FLAG
, PRC.SUBMTD_DT
, PRC.TTL_RQST_AMT
, PRC.APRVD_FOR_PYMT_AMT
, PRC.PRC_ATTRIBUTE_CATEGORY
, PRC.PRC_ATTRIBUTE1
, PRC.PRC_ATTRIBUTE2
, PRC.PRC_ATTRIBUTE3
, PRC.PRC_ATTRIBUTE4
, PRC.PRC_ATTRIBUTE5
, PRC.PRC_ATTRIBUTE6
, PRC.PRC_ATTRIBUTE7
, PRC.PRC_ATTRIBUTE8
, PRC.PRC_ATTRIBUTE9
, PRC.PRC_ATTRIBUTE10
, PRC.PRC_ATTRIBUTE11
, PRC.PRC_ATTRIBUTE12
, PRC.PRC_ATTRIBUTE13
, PRC.PRC_ATTRIBUTE14
, PRC.PRC_ATTRIBUTE15
, PRC.PRC_ATTRIBUTE16
, PRC.PRC_ATTRIBUTE17
, PRC.PRC_ATTRIBUTE18
, PRC.PRC_ATTRIBUTE19
, PRC.PRC_ATTRIBUTE20
, PRC.PRC_ATTRIBUTE21
, PRC.PRC_ATTRIBUTE22
, PRC.PRC_ATTRIBUTE23
, PRC.PRC_ATTRIBUTE24
, PRC.PRC_ATTRIBUTE25
, PRC.PRC_ATTRIBUTE26
, PRC.PRC_ATTRIBUTE27
, PRC.PRC_ATTRIBUTE28
, PRC.PRC_ATTRIBUTE29
, PRC.PRC_ATTRIBUTE30
, PRC.LAST_UPDATE_DATE
, PRC.LAST_UPDATED_BY
, PRC.LAST_UPDATE_LOGIN
, PRC.CREATED_BY
, PRC.CREATION_DATE
, PRC.OBJECT_VERSION_NUMBER
FROM BEN_PRTT_REIMBMT_RQST_F PRC
WHERE PRC.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PRC.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
PRTT_REIMBMT_RQST_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
INCRD_FROM_DT
INCRD_TO_DT
EXP_INCURD_DT
RQST_NUM
RQST_AMT
RQST_AMT_UOM
RQST_BTCH_NUM
PRTT_REIMBMT_RQST_STAT_CD
REIMBMT_CTFN_TYP_PRVDD_CD
RCRRG_CD
SUBMITTER_PERSON_ID
RECIPIENT_PERSON_ID
PROVIDER_PERSON_ID
PROVIDER_SSN_PERSON_ID
PL_ID
GD_OR_SVC_TYP_ID
CONTACT_RELATIONSHIP_ID
BUSINESS_GROUP_ID
PRTT_ENRT_RSLT_ID
COMMENT_ID
STAT_RSN_CD
PYMT_STAT_CD
PYMT_STAT_RSN_CD
STAT_OVRDN_FLAG
STAT_OVRDN_RSN_CD
STAT_PRR_TO_OVRD
PYMT_STAT_OVRDN_FLAG
PYMT_STAT_OVRDN_RSN_CD
PYMT_STAT_PRR_TO_OVRD
ADJMT_FLAG
SUBMTD_DT
TTL_RQST_AMT
APRVD_FOR_PYMT_AMT
PRC_ATTRIBUTE_CATEGORY
PRC_ATTRIBUTE1
PRC_ATTRIBUTE2
PRC_ATTRIBUTE3
PRC_ATTRIBUTE4
PRC_ATTRIBUTE5
PRC_ATTRIBUTE6
PRC_ATTRIBUTE7
PRC_ATTRIBUTE8
PRC_ATTRIBUTE9
PRC_ATTRIBUTE10
PRC_ATTRIBUTE11
PRC_ATTRIBUTE12
PRC_ATTRIBUTE13
PRC_ATTRIBUTE14
PRC_ATTRIBUTE15
PRC_ATTRIBUTE16
PRC_ATTRIBUTE17
PRC_ATTRIBUTE18
PRC_ATTRIBUTE19
PRC_ATTRIBUTE20
PRC_ATTRIBUTE21
PRC_ATTRIBUTE22
PRC_ATTRIBUTE23
PRC_ATTRIBUTE24
PRC_ATTRIBUTE25
PRC_ATTRIBUTE26
PRC_ATTRIBUTE27
PRC_ATTRIBUTE28
PRC_ATTRIBUTE29
PRC_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER