1. Tables and Views for Sales and Fusion 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,

HcmUsers.USERNAME

From

JTF_RS_RESOURCE_PROFILES ResProfiles,

HZ_PARTIES HzParties,

HZ_ORIG_SYS_REFERENCES OSR,

PER_USERS HcmUsers

WHERE

ResProfiles.PARTY_ID = HzParties.PARTY_ID

AND HzParties.STATUS = 'A'

AND HzParties.PARTY_ID = OSR.OWNER_TABLE_ID

AND OSR.ORIG_SYSTEM = 'FUSION_HCM'

AND OSR.STATUS = 'A'

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

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

AND OSR.ORIG_SYSTEM_REFERENCE = HcmUsers.PERSON_ID (+)