View: XLE_FP_REGISTRATIONS_V

Product:	XLE - Legal Entity Configurator
Description:
Implementation/DBA Data:	APPS.XLE_FP_REGISTRATIONS_V

View Text

SELECT LEP.LEGAL_ENTITY_ID
, LEP.NAME LEGAL_ENTITY_NAME
, LEP.PARTY_ID
, REG.REGISTRATION_NUMBER
, JUR.IDENTIFYING_FLAG IDENTIFYING
, JUR.LEGISLATIVE_CAT_CODE LEGISLATIVE_CATEGORY
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE PARTY_ID = REG.ISSUING_AUTHORITY_ID) LEGALAUTH_NAME
, (SELECT HZL.ADDRESS1 || ' ' || HZL.ADDRESS2 || ' ' || HZL.CITY || '
, ' || HZL.STATE || '
, ' || HZL.COUNTRY || ' ' || HZL.POSTAL_CODE
FROM HZ_LOCATIONS HZL
, HZ_PARTY_SITES HPS
WHERE HPS.LOCATION_ID = HZL.LOCATION_ID
AND HPS.PARTY_SITE_ID = REG.ISSUING_AUTHORITY_SITE_ID) LEGALAUTH_ADDRESS
, REG.EFFECTIVE_FROM
, REG.EFFECTIVE_TO
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.TOWN_OR_CITY
, HRL.REGION_1
, HRL.POSTAL_CODE
, HRL.COUNTRY
FROM XLE_ENTITY_PROFILES LEP
, XLE_REGISTRATIONS REG
, HR_LOCATIONS_ALL HRL
, XLE_JURISDICTIONS_VL JUR WHERE LEP.TRANSACTING_ENTITY_FLAG = 'Y'
AND LEP.LEGAL_ENTITY_ID = REG.SOURCE_ID
AND REG.SOURCE_TABLE = 'XLE_ENTITY_PROFILES'
AND HRL.LOCATION_ID = REG.LOCATION_ID
AND JUR.JURISDICTION_ID = REG.JURISDICTION_ID