VIEW: APPS.AMS_JTF_RS_EMP_V

Source

View Text - Preformatted

SELECT /*+ FIRST_ROWS */ B.RESOURCE_ID , B.CREATED_BY ,B.CREATION_DATE , B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN ,B.RESOURCE_NUMBER , B.SOURCE_ID EMPLOYEE_ID ,B.ADDRESS_ID , B.CONTACT_ID ,B.START_DATE_ACTIVE ,B.END_DATE_ACTIVE , B.OBJECT_VERSION_NUMBER ,B.ATTRIBUTE1 ,B.ATTRIBUTE2 , B.ATTRIBUTE3 ,B.ATTRIBUTE4 ,B.ATTRIBUTE5 , B.ATTRIBUTE6 ,B.ATTRIBUTE7 ,B.ATTRIBUTE8 , B.ATTRIBUTE9 ,B.ATTRIBUTE10 ,B.ATTRIBUTE11 , B.ATTRIBUTE12 ,B.ATTRIBUTE13 ,B.ATTRIBUTE14 , B.ATTRIBUTE15 ,B.ATTRIBUTE_CATEGORY , B.USER_ID , TL.RESOURCE_NAME ,TL.RESOURCE_NAME FULL_NAME , B.SOURCE_NUMBER EMPLOYEE_NUMBER , B.SOURCE_JOB_TITLE JOB_TITLE , B.SOURCE_EMAIL EMAIL ,B.SOURCE_PHONE PHONE , B.SOURCE_ORG_ID ORG_ID ,B.SOURCE_ORG_NAME ORG_NAME , B.SOURCE_ADDRESS1 ADDRESS1 ,B.SOURCE_ADDRESS2 ADDRESS2 , B.SOURCE_ADDRESS3 ADDRESS3 ,B.SOURCE_ADDRESS4 ADDRESS4 , B.SOURCE_CITY CITY ,B.SOURCE_POSTAL_CODE POSTAL_CODE , B.SOURCE_STATE STATE ,B.SOURCE_PROVINCE PROVINCE , B.SOURCE_COUNTY COUNTY ,B.SOURCE_COUNTRY COUNTRY , B.SOURCE_MGR_ID MANAGER_ID ,B.SOURCE_MGR_NAME MANAGER_NAME , B.SOURCE_FIRST_NAME FIRST_NAME , B.SOURCE_MIDDLE_NAME MIDDLE_NAME , B.SOURCE_LAST_NAME LAST_NAME ,B.CATEGORY CATEGORY , B.SOURCE_STATUS STATUS from jtf_rs_resource_extns b, jtf_rs_resource_extns_tl tl WHERE B.resource_id > 0 AND B.resource_id = TL.resource_id AND TL.language = USERENV('LANG') AND (B.category = 'EMPLOYEE' OR B.category = 'PARTNER' OR B.category = 'PARTY')

View Text - HTML Formatted

SELECT /*+ FIRST_ROWS */ B.RESOURCE_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.RESOURCE_NUMBER
, B.SOURCE_ID EMPLOYEE_ID
, B.ADDRESS_ID
, B.CONTACT_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.OBJECT_VERSION_NUMBER
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE_CATEGORY
, B.USER_ID
, TL.RESOURCE_NAME
, TL.RESOURCE_NAME FULL_NAME
, B.SOURCE_NUMBER EMPLOYEE_NUMBER
, B.SOURCE_JOB_TITLE JOB_TITLE
, B.SOURCE_EMAIL EMAIL
, B.SOURCE_PHONE PHONE
, B.SOURCE_ORG_ID ORG_ID
, B.SOURCE_ORG_NAME ORG_NAME
, B.SOURCE_ADDRESS1 ADDRESS1
, B.SOURCE_ADDRESS2 ADDRESS2
, B.SOURCE_ADDRESS3 ADDRESS3
, B.SOURCE_ADDRESS4 ADDRESS4
, B.SOURCE_CITY CITY
, B.SOURCE_POSTAL_CODE POSTAL_CODE
, B.SOURCE_STATE STATE
, B.SOURCE_PROVINCE PROVINCE
, B.SOURCE_COUNTY COUNTY
, B.SOURCE_COUNTRY COUNTRY
, B.SOURCE_MGR_ID MANAGER_ID
, B.SOURCE_MGR_NAME MANAGER_NAME
, B.SOURCE_FIRST_NAME FIRST_NAME
, B.SOURCE_MIDDLE_NAME MIDDLE_NAME
, B.SOURCE_LAST_NAME LAST_NAME
, B.CATEGORY CATEGORY
, B.SOURCE_STATUS STATUS
FROM JTF_RS_RESOURCE_EXTNS B
, JTF_RS_RESOURCE_EXTNS_TL TL
WHERE B.RESOURCE_ID > 0
AND B.RESOURCE_ID = TL.RESOURCE_ID
AND TL.LANGUAGE = USERENV('LANG')
AND (B.CATEGORY = 'EMPLOYEE' OR B.CATEGORY = 'PARTNER' OR B.CATEGORY = 'PARTY')