eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XLE_FP_ESTABLISHMENT_V

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

View Text

SELECT ETBP.ESTABLISHMENT_ID
, ETBP.NAME ESTABLISHMENT_NAME
, ETBP.PARTY_ID
, ETBP.LEGAL_ENTITY_ID
, ETBP.MAIN_ESTABLISHMENT_FLAG
, ETBP.ACTIVITY_CODE
, ETBP.SUB_ACTIVITY_CODE
, REG.REGISTRATION_NUMBER
, REG.IDENTIFYING_FLAG
, JUR.LEGISLATIVE_CAT_CODE
, 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_ETB_PROFILES ETBP
, XLE_ENTITY_PROFILES LEP
, XLE_REGISTRATIONS REG
, HR_LOCATIONS_ALL HRL
, XLE_JURISDICTIONS_VL JUR WHERE ETBP.ESTABLISHMENT_ID = REG.SOURCE_ID
AND LEP.LEGAL_ENTITY_ID = ETBP.LEGAL_ENTITY_ID
AND REG.SOURCE_TABLE = 'XLE_ETB_PROFILES'
AND HRL.LOCATION_ID = REG.LOCATION_ID
AND REG.IDENTIFYING_FLAG = 'Y'
AND JUR.JURISDICTION_ID = REG.JURISDICTION_ID