VIEW: APPS.CN_SRP_HR_DATA

Source

View Text - Preformatted

SELECT S.SALESREP_ID SRP_ID, RE.RESOURCE_NAME NAME, S.RESOURCE_ID, S.SALESREP_NUMBER EMP_NUM, S.START_DATE_ACTIVE START_DATE, S.END_DATE_ACTIVE END_DATE, RE.COST_CENTER , RE.CATEGORY, S.ORG_ID , S.ATTRIBUTE_CATEGORY , S.ATTRIBUTE1 , S.ATTRIBUTE2 , S.ATTRIBUTE3 , S.ATTRIBUTE4 , S.ATTRIBUTE5 , S.ATTRIBUTE6 , S.ATTRIBUTE7 , S.ATTRIBUTE8 , S.ATTRIBUTE9 , S.ATTRIBUTE10 , S.ATTRIBUTE11 , S.ATTRIBUTE12 , S.ATTRIBUTE13 , S.ATTRIBUTE14 , S.ATTRIBUTE15 , S.CREATION_DATE , S.CREATED_BY , S.LAST_UPDATE_DATE , S.LAST_UPDATE_LOGIN , S.LAST_UPDATED_BY FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND NVL (S.ORG_ID,NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO') ,1,1 ) , ' ', NULL, SUBSTRB ( USERENV ( 'CLIENT_INFO') ,1,10 ) ) ) ,-99 ) ) = NVL (TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO') ,1,1 ) , ' ', NULL, SUBSTRB ( USERENV ( 'CLIENT_INFO') ,1,10 ) ) ) ,-99 )

View Text - HTML Formatted

SELECT S.SALESREP_ID SRP_ID
, RE.RESOURCE_NAME NAME
, S.RESOURCE_ID
, S.SALESREP_NUMBER EMP_NUM
, S.START_DATE_ACTIVE START_DATE
, S.END_DATE_ACTIVE END_DATE
, RE.COST_CENTER
, RE.CATEGORY
, S.ORG_ID
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATE_LOGIN
, S.LAST_UPDATED_BY
FROM JTF_RS_RESOURCE_EXTNS_VL RE
, JTF_RS_SALESREPS S
WHERE RE.RESOURCE_ID = S.RESOURCE_ID
AND TO_NUMBER(S.SALESREP_ID) > 0
AND NVL (S.ORG_ID
, NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO')
, 1
, 1 )
, ' '
, NULL
, SUBSTRB ( USERENV ( 'CLIENT_INFO')
, 1
, 10 ) ) )
, -99 ) ) = NVL (TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO')
, 1
, 1 )
, ' '
, NULL
, SUBSTRB ( USERENV ( 'CLIENT_INFO')
, 1
, 10 ) ) )
, -99 )