VIEW: APPS.BEN_ORG_UNIT_RT_X

Source

View Text - Preformatted

SELECT OUR.ORG_UNIT_RT_ID , OUR.EFFECTIVE_START_DATE , OUR.EFFECTIVE_END_DATE , OUR.BUSINESS_GROUP_ID , OUR.VRBL_RT_PRFL_ID , OUR.ORGANIZATION_ID , OUR.EXCLD_FLAG , OUR.ORDR_NUM , OUR.OUR_ATTRIBUTE_CATEGORY , OUR.OUR_ATTRIBUTE1 , OUR.OUR_ATTRIBUTE2 , OUR.OUR_ATTRIBUTE3 , OUR.OUR_ATTRIBUTE4 , OUR.OUR_ATTRIBUTE5 , OUR.OUR_ATTRIBUTE6 , OUR.OUR_ATTRIBUTE7 , OUR.OUR_ATTRIBUTE8 , OUR.OUR_ATTRIBUTE9 , OUR.OUR_ATTRIBUTE10 , OUR.OUR_ATTRIBUTE11 , OUR.OUR_ATTRIBUTE12 , OUR.OUR_ATTRIBUTE13 , OUR.OUR_ATTRIBUTE14 , OUR.OUR_ATTRIBUTE15 , OUR.OUR_ATTRIBUTE16 , OUR.OUR_ATTRIBUTE17 , OUR.OUR_ATTRIBUTE18 , OUR.OUR_ATTRIBUTE19 , OUR.OUR_ATTRIBUTE20 , OUR.OUR_ATTRIBUTE21 , OUR.OUR_ATTRIBUTE22 , OUR.OUR_ATTRIBUTE23 , OUR.OUR_ATTRIBUTE24 , OUR.OUR_ATTRIBUTE25 , OUR.OUR_ATTRIBUTE26 , OUR.OUR_ATTRIBUTE27 , OUR.OUR_ATTRIBUTE28 , OUR.OUR_ATTRIBUTE29 , OUR.OUR_ATTRIBUTE30 , OUR.LAST_UPDATE_DATE , OUR.LAST_UPDATED_BY , OUR.LAST_UPDATE_LOGIN , OUR.CREATED_BY , OUR.CREATION_DATE , OUR.OBJECT_VERSION_NUMBER FROM BEN_ORG_UNIT_RT_F OUR WHERE TRUNC(SYSDATE) BETWEEN OUR.EFFECTIVE_START_DATE AND OUR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT OUR.ORG_UNIT_RT_ID
, OUR.EFFECTIVE_START_DATE
, OUR.EFFECTIVE_END_DATE
, OUR.BUSINESS_GROUP_ID
, OUR.VRBL_RT_PRFL_ID
, OUR.ORGANIZATION_ID
, OUR.EXCLD_FLAG
, OUR.ORDR_NUM
, OUR.OUR_ATTRIBUTE_CATEGORY
, OUR.OUR_ATTRIBUTE1
, OUR.OUR_ATTRIBUTE2
, OUR.OUR_ATTRIBUTE3
, OUR.OUR_ATTRIBUTE4
, OUR.OUR_ATTRIBUTE5
, OUR.OUR_ATTRIBUTE6
, OUR.OUR_ATTRIBUTE7
, OUR.OUR_ATTRIBUTE8
, OUR.OUR_ATTRIBUTE9
, OUR.OUR_ATTRIBUTE10
, OUR.OUR_ATTRIBUTE11
, OUR.OUR_ATTRIBUTE12
, OUR.OUR_ATTRIBUTE13
, OUR.OUR_ATTRIBUTE14
, OUR.OUR_ATTRIBUTE15
, OUR.OUR_ATTRIBUTE16
, OUR.OUR_ATTRIBUTE17
, OUR.OUR_ATTRIBUTE18
, OUR.OUR_ATTRIBUTE19
, OUR.OUR_ATTRIBUTE20
, OUR.OUR_ATTRIBUTE21
, OUR.OUR_ATTRIBUTE22
, OUR.OUR_ATTRIBUTE23
, OUR.OUR_ATTRIBUTE24
, OUR.OUR_ATTRIBUTE25
, OUR.OUR_ATTRIBUTE26
, OUR.OUR_ATTRIBUTE27
, OUR.OUR_ATTRIBUTE28
, OUR.OUR_ATTRIBUTE29
, OUR.OUR_ATTRIBUTE30
, OUR.LAST_UPDATE_DATE
, OUR.LAST_UPDATED_BY
, OUR.LAST_UPDATE_LOGIN
, OUR.CREATED_BY
, OUR.CREATION_DATE
, OUR.OBJECT_VERSION_NUMBER
FROM BEN_ORG_UNIT_RT_F OUR
WHERE TRUNC(SYSDATE) BETWEEN OUR.EFFECTIVE_START_DATE
AND OUR.EFFECTIVE_END_DATE