1. Tables and Views for Sales, Fusion Service, and Field Service
  2. JTF_IMP_RESOURCE_PROFILES_V

JTF_IMP_RESOURCE_PROFILES_V

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

RESOURCE_PROFILE_ID

PARTY_ID

PARTY_NUMBER

EMAIL_ADDRESS

USERNAME

Query

SQL_Statement

SELECT

ResProfiles.RESOURCE_PROFILE_ID,

ResProfiles.PARTY_ID,

HzParties.PARTY_NUMBER,

ResProfiles.EMAIL_ADDRESS,

(SELECT HcmUsers.USERNAME

FROM PER_USERS HcmUsers

WHERE HcmUsers.PERSON_ID = DECODE(VALIDATE_CONVERSION(OSR.orig_system_reference AS NUMBER),1,TO_NUMBER(OSR.orig_system_reference),NULL)

AND ROWNUM=1) USERNAME

From

JTF_RS_RESOURCE_PROFILES ResProfiles,

HZ_PARTIES HzParties,

HZ_ORIG_SYS_REFERENCES OSR

WHERE

ResProfiles.PARTY_ID = HzParties.PARTY_ID

AND HzParties.STATUS = 'A'

AND HzParties.PARTY_ID = OSR.OWNER_TABLE_ID

AND OSR.OWNER_TABLE_NAME= 'HZ_PARTIES'

AND OSR.ORIG_SYSTEM = 'FUSION_HCM'

AND OSR.STATUS = 'A'

AND trunc (SYSDATE) BETWEEN OSR.START_DATE_ACTIVE AND OSR.END_DATE_ACTIVE

AND trunc (SYSDATE) BETWEEN ResProfiles.START_DATE_ACTIVE AND ResProfiles.END_DATE_ACTIVE