VIEW: APPS.JTF_RS_RESOURCE_EXTNS_VL

Source

View Text - Preformatted

SELECT b.rowid ROW_ID , b.RESOURCE_ID , b.CREATED_BY , b.CREATION_DATE , b.LAST_UPDATED_BY , b.LAST_UPDATE_DATE , b.LAST_UPDATE_LOGIN , b.CATEGORY , b.RESOURCE_NUMBER , b.SOURCE_ID , b.ADDRESS_ID , b.CONTACT_ID , b.MANAGING_EMPLOYEE_ID , b.START_DATE_ACTIVE , b.END_DATE_ACTIVE , b.TIME_ZONE , b.COST_PER_HR , b.PRIMARY_LANGUAGE , b.SECONDARY_LANGUAGE , b.IES_AGENT_LOGIN , b.SERVER_GROUP_ID , b.ASSIGNED_TO_GROUP_ID , b.COST_CENTER , b.CHARGE_TO_COST_CENTER , b.COMPENSATION_CURRENCY_CODE , b.COMMISSIONABLE_FLAG , b.HOLD_REASON_CODE , b.HOLD_PAYMENT , b.COMP_SERVICE_TEAM_ID , b.TRANSACTION_NUMBER, 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 , b.SUPPORT_SITE_ID , t.RESOURCE_NAME , b.SOURCE_NAME , b.SOURCE_NUMBER , b.SOURCE_JOB_TITLE , b.SOURCE_EMAIL , b.SOURCE_PHONE , b.SOURCE_ORG_ID , b.SOURCE_ORG_NAME , b.SOURCE_ADDRESS1 , b.SOURCE_ADDRESS2 , b.SOURCE_ADDRESS3 , b.SOURCE_ADDRESS4 , b.SOURCE_CITY , b.SOURCE_POSTAL_CODE , b.SOURCE_STATE , b.SOURCE_PROVINCE , b.SOURCE_COUNTY , b.SOURCE_COUNTRY , b.SOURCE_MGR_ID , b.SOURCE_MGR_NAME , b.SOURCE_BUSINESS_GRP_ID , b.SOURCE_BUSINESS_GRP_NAME , b.SOURCE_FIRST_NAME , b.SOURCE_MIDDLE_NAME , b.SOURCE_LAST_NAME , b.SOURCE_CATEGORY , b.SOURCE_STATUS , b.USER_NAME , b.SOURCE_OFFICE , b.SOURCE_LOCATION, b.SOURCE_MAILSTOP , b.SOURCE_MOBILE_PHONE, b.SOURCE_PAGER, b.SOURCE_JOB_ID, b.PERSON_PARTY_ID, b.FS_SETUP_COMPLETE from jtf_rs_resource_extns b, jtf_rs_resource_extns_tl t WHERE t.language = userenv('LANG') and b.resource_id = t.resource_id and b.category = t.category

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RESOURCE_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CATEGORY
, B.RESOURCE_NUMBER
, B.SOURCE_ID
, B.ADDRESS_ID
, B.CONTACT_ID
, B.MANAGING_EMPLOYEE_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.TIME_ZONE
, B.COST_PER_HR
, B.PRIMARY_LANGUAGE
, B.SECONDARY_LANGUAGE
, B.IES_AGENT_LOGIN
, B.SERVER_GROUP_ID
, B.ASSIGNED_TO_GROUP_ID
, B.COST_CENTER
, B.CHARGE_TO_COST_CENTER
, B.COMPENSATION_CURRENCY_CODE
, B.COMMISSIONABLE_FLAG
, B.HOLD_REASON_CODE
, B.HOLD_PAYMENT
, B.COMP_SERVICE_TEAM_ID
, B.TRANSACTION_NUMBER
, 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
, B.SUPPORT_SITE_ID
, T.RESOURCE_NAME
, B.SOURCE_NAME
, B.SOURCE_NUMBER
, B.SOURCE_JOB_TITLE
, B.SOURCE_EMAIL
, B.SOURCE_PHONE
, B.SOURCE_ORG_ID
, B.SOURCE_ORG_NAME
, B.SOURCE_ADDRESS1
, B.SOURCE_ADDRESS2
, B.SOURCE_ADDRESS3
, B.SOURCE_ADDRESS4
, B.SOURCE_CITY
, B.SOURCE_POSTAL_CODE
, B.SOURCE_STATE
, B.SOURCE_PROVINCE
, B.SOURCE_COUNTY
, B.SOURCE_COUNTRY
, B.SOURCE_MGR_ID
, B.SOURCE_MGR_NAME
, B.SOURCE_BUSINESS_GRP_ID
, B.SOURCE_BUSINESS_GRP_NAME
, B.SOURCE_FIRST_NAME
, B.SOURCE_MIDDLE_NAME
, B.SOURCE_LAST_NAME
, B.SOURCE_CATEGORY
, B.SOURCE_STATUS
, B.USER_NAME
, B.SOURCE_OFFICE
, B.SOURCE_LOCATION
, B.SOURCE_MAILSTOP
, B.SOURCE_MOBILE_PHONE
, B.SOURCE_PAGER
, B.SOURCE_JOB_ID
, B.PERSON_PARTY_ID
, B.FS_SETUP_COMPLETE
FROM JTF_RS_RESOURCE_EXTNS B
, JTF_RS_RESOURCE_EXTNS_TL T
WHERE T.LANGUAGE = USERENV('LANG')
AND B.RESOURCE_ID = T.RESOURCE_ID
AND B.CATEGORY = T.CATEGORY