VIEW: APPS.JTF_RS_EMP_DTLS_VL

Source

View Text - Preformatted

SELECT rsc.RESOURCE_ID ,rsc.resource_number RESOURCE_NUMBER ,rsc.source_id SOURCE_ID ,rsc.address_id ADDRESS_ID ,rsc.contact_id CONTACT_ID ,rsc.START_DATE_ACTIVE ,rsc.END_DATE_ACTIVE , rsc.TIME_ZONE ,rsc.COST_PER_HR ,rsc.PRIMARY_LANGUAGE ,rsc.SECONDARY_LANGUAGE ,rsc.SUPPORT_SITE_ID ,rsc.IES_AGENT_LOGIN ,rsc.SERVER_GROUP_ID ,rsc.ASSIGNED_TO_GROUP_ID ,rsc.COST_CENTER ,rsc.CHARGE_TO_COST_CENTER ,rsc.COMPENSATION_CURRENCY_CODE ,rsc.COMMISSIONABLE_FLAG ,rsc.HOLD_REASON_CODE ,rsc.HOLD_PAYMENT ,rsc.COMP_SERVICE_TEAM_ID ,rsc.TRANSACTION_NUMBER , rsc.SOURCE_FIRST_NAME FIRST_NAME , rsc.SOURCE_LAST_NAME LAST_NAME , rsc.SOURCE_MIDDLE_NAME MIDDLE_NAME , rsc.source_name FULL_NAME , rsc.source_number EMPLOYEE_NUMBER , rsc.source_phone PHONE , rsc.source_email EMAIL , rsc.source_job_title JOB_TITLE , rsc.source_mgr_id MANAGER_PERSON_ID , rsc.source_mgr_name MANAGER_NAME , rsc.start_date_active EFFECTIVE_START_DATE , rsc.end_date_active EFFECTIVE_END_DATE , rsc.source_category EMP_CATEGORY , rsc.source_status EMP_STATUS , rsc.source_business_grp_id ORG_ID , rsc.source_business_grp_name ORG_NAME , rsc.user_id USER_ID ,rsc.resource_name ,rsc.source_job_id JOB_ID ,rsc.person_party_id PERSON_PARTY_ID from jtf_rs_resource_extns_vl rsc WHERE rsc.category = 'EMPLOYEE'

View Text - HTML Formatted

SELECT RSC.RESOURCE_ID
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.SOURCE_ID SOURCE_ID
, RSC.ADDRESS_ID ADDRESS_ID
, RSC.CONTACT_ID CONTACT_ID
, RSC.START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE
, RSC.TIME_ZONE
, RSC.COST_PER_HR
, RSC.PRIMARY_LANGUAGE
, RSC.SECONDARY_LANGUAGE
, RSC.SUPPORT_SITE_ID
, RSC.IES_AGENT_LOGIN
, RSC.SERVER_GROUP_ID
, RSC.ASSIGNED_TO_GROUP_ID
, RSC.COST_CENTER
, RSC.CHARGE_TO_COST_CENTER
, RSC.COMPENSATION_CURRENCY_CODE
, RSC.COMMISSIONABLE_FLAG
, RSC.HOLD_REASON_CODE
, RSC.HOLD_PAYMENT
, RSC.COMP_SERVICE_TEAM_ID
, RSC.TRANSACTION_NUMBER
, RSC.SOURCE_FIRST_NAME FIRST_NAME
, RSC.SOURCE_LAST_NAME LAST_NAME
, RSC.SOURCE_MIDDLE_NAME MIDDLE_NAME
, RSC.SOURCE_NAME FULL_NAME
, RSC.SOURCE_NUMBER EMPLOYEE_NUMBER
, RSC.SOURCE_PHONE PHONE
, RSC.SOURCE_EMAIL EMAIL
, RSC.SOURCE_JOB_TITLE JOB_TITLE
, RSC.SOURCE_MGR_ID MANAGER_PERSON_ID
, RSC.SOURCE_MGR_NAME MANAGER_NAME
, RSC.START_DATE_ACTIVE EFFECTIVE_START_DATE
, RSC.END_DATE_ACTIVE EFFECTIVE_END_DATE
, RSC.SOURCE_CATEGORY EMP_CATEGORY
, RSC.SOURCE_STATUS EMP_STATUS
, RSC.SOURCE_BUSINESS_GRP_ID ORG_ID
, RSC.SOURCE_BUSINESS_GRP_NAME ORG_NAME
, RSC.USER_ID USER_ID
, RSC.RESOURCE_NAME
, RSC.SOURCE_JOB_ID JOB_ID
, RSC.PERSON_PARTY_ID PERSON_PARTY_ID
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE RSC.CATEGORY = 'EMPLOYEE'