View: AMS_JTF_RS_EMP_V

Product:	AMS - Marketing
Description:	This view is created to give the details of the Marketing resources
Implementation/DBA Data:	APPS.AMS_JTF_RS_EMP_V

View Text

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')

Columns