FT_INST_CMP_VW

(SQL View)
 Index Back

FT Install - Legal Entities

List of Legal Entities imported via the Fusion Legal Entity manual XREF process, to be used as a prompt for Company on the Fusion Talent Management Integration Installation Options page

SELECT C1.COMPANY , C1.DESCR FROM %Table(COMPANY_TBL) C1 WHERE C1.EFFDT = ( SELECT MAX(C2.EFFDT) FROM %Table(COMPANY_TBL) C2 WHERE C1.COMPANY = C2.COMPANY AND C2.EFFDT <= %CurrentDateIn) AND C1.EFF_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM %Table(EOTF_DVMVALS_VW) DV , %Table(EOTF_ELEMENTS) EL , %Table(EOTF_ELEMENTSET) ES , %Table(FT_INSTALL) FT WHERE DV.EOTF_MAP_NAME = 'LEGAL_ENTITY_XREF' AND DV.EOTF_ELEMENT_VALUE = C1.COMPANY AND ES.EOTF_DOMAIN_NAME = FT.FT_DOMAIN_SOURCE AND %Join(COMMON_FIELDS, EOTF_DVMVALS_VW DV, EOTF_ELEMENTS EL) AND %Join(COMMON_KEYS, EOTF_ELEMENTS EL, EOTF_ELEMENTSET ES))

  • Related Language Record: FT_INST_CMP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description