VIEW: APPS.JTF_RS_RESOURCE_DTLS_VL

Source

View Text - Preformatted

SELECT rsc.resource_id RESOURCE_ID ,rsc.category CATEGORY ,rsc.resource_number RESOURCE_NUMBER ,rsc.resource_name RESOURCE_NAME ,rsc.source_id SOURCE_ID ,rsc.address_id ADDRESS_ID ,rsc.contact_id CONTACT_ID ,rsc.managing_employee_id MANAGING_EMPLOYEE_ID ,rsc.support_site_id SUPPORT_SITE_iD ,decode(rsc.category,'EMPLOYEE',rsc.source_business_grp_id,rsc.source_org_id) ORG_ID ,decode(rsc.category,'EMPLOYEE',rsc.source_business_grp_name,rsc.source_org_name ) ORG_NAME ,rsc.source_email EMAIL ,rsc.start_date_active START_DATE_ACTIVE ,rsc.end_date_active END_DATE_ACTIVE ,rsc.source_phone PHONE ,rsc.user_id USER_ID,rsc.person_party_id PERSON_PARTY_ID from jtf_rs_resource_extns_vl rsc WHERE rsc.category IN ('EMPLOYEE','PARTNER','PARTY','SUPPLIER_CONTACT') UNION ALL select rsc.resource_id RESOURCE_ID ,rsc.category CATEGOR ,rsc.resource_number RESOURCE_NUMBER ,rsc.resource_name RESOURCE_NAME ,rsc.source_id SOURCE_ID ,rsc.address_id ADDRESS_ID ,rsc.contact_id CONTACT_ID ,rsc.managing_employee_id MANAGING_EMPLOYEE_ID ,rsc.support_site_id SUPPORT_SITE_ID ,srp.org_id ORG_ID ,org.name ORG_NAME , srp.email_address EMAIL ,rsc.start_date_active START_DATE_ACTIVE , rsc.end_date_active END_DATE_ACTIVE , NULL PHONE ,rsc.user_id USER_ID ,to_number(NULL) PARTY_ID from jtf_rs_resource_extns_vl rsc , jtf_rs_salesreps_mo_v srp , hr_organization_units org where rsc.category in ('OTHER', 'TBH') and srp.resource_id = rsc.resource_id and srp.org_id = org.organization_id(+)

View Text - HTML Formatted

SELECT RSC.RESOURCE_ID RESOURCE_ID
, RSC.CATEGORY CATEGORY
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.SOURCE_ID SOURCE_ID
, RSC.ADDRESS_ID ADDRESS_ID
, RSC.CONTACT_ID CONTACT_ID
, RSC.MANAGING_EMPLOYEE_ID MANAGING_EMPLOYEE_ID
, RSC.SUPPORT_SITE_ID SUPPORT_SITE_ID
, DECODE(RSC.CATEGORY
, 'EMPLOYEE'
, RSC.SOURCE_BUSINESS_GRP_ID
, RSC.SOURCE_ORG_ID) ORG_ID
, DECODE(RSC.CATEGORY
, 'EMPLOYEE'
, RSC.SOURCE_BUSINESS_GRP_NAME
, RSC.SOURCE_ORG_NAME ) ORG_NAME
, RSC.SOURCE_EMAIL EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, RSC.SOURCE_PHONE PHONE
, RSC.USER_ID USER_ID
, RSC.PERSON_PARTY_ID PERSON_PARTY_ID
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
WHERE RSC.CATEGORY IN ('EMPLOYEE'
, 'PARTNER'
, 'PARTY'
, 'SUPPLIER_CONTACT') UNION ALL SELECT RSC.RESOURCE_ID RESOURCE_ID
, RSC.CATEGORY CATEGOR
, RSC.RESOURCE_NUMBER RESOURCE_NUMBER
, RSC.RESOURCE_NAME RESOURCE_NAME
, RSC.SOURCE_ID SOURCE_ID
, RSC.ADDRESS_ID ADDRESS_ID
, RSC.CONTACT_ID CONTACT_ID
, RSC.MANAGING_EMPLOYEE_ID MANAGING_EMPLOYEE_ID
, RSC.SUPPORT_SITE_ID SUPPORT_SITE_ID
, SRP.ORG_ID ORG_ID
, ORG.NAME ORG_NAME
, SRP.EMAIL_ADDRESS EMAIL
, RSC.START_DATE_ACTIVE START_DATE_ACTIVE
, RSC.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL PHONE
, RSC.USER_ID USER_ID
, TO_NUMBER(NULL) PARTY_ID
FROM JTF_RS_RESOURCE_EXTNS_VL RSC
, JTF_RS_SALESREPS_MO_V SRP
, HR_ORGANIZATION_UNITS ORG
WHERE RSC.CATEGORY IN ('OTHER'
, 'TBH')
AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
AND SRP.ORG_ID = ORG.ORGANIZATION_ID(+)