1. Tables and Views for Financials
  2. XLE_FIRSTPARTY_INFORMATION_V

XLE_FIRSTPARTY_INFORMATION_V

Details

  • Schema: FUSION

  • Object owner: XLE

  • Object type: VIEW

Columns

Name

LEGAL_ENTITY_ID

GEOGRAPHY_ID

LE_INFORMATION_CONTEXT

NAME

PARTY_ID

LEGAL_ENTITY_IDENTIFIER

ACTIVITY_CODE

SUB_ACTIVITY_CODE

TYPE_OF_COMPANY

ACTIVITY_CATEGORY

ACTIVITY_DESCRIPTION

LE_EFFECTIVE_FROM

LE_EFFECTIVE_TO

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

REGISTRATION_NUMBER

LEGISLATIVE_CAT_CODE

EFFECTIVE_FROM

EFFECTIVE_TO

LOCATION_ID

ADDRESS_STYLE

ADDRESS_LINE_1

ADDRESS_LINE_2

ADDRESS_LINE_3

TOWN_OR_CITY

REGION_1

REGION_2

REGION_3

POSTAL_CODE

COUNTRY

Query

SQL_Statement

SELECT lep.legal_entity_id,

lep.geography_id,

lep.le_information_context,

lep.name,

lep.party_id,

lep.legal_entity_identifier,

lep.activity_code,

lep.sub_activity_code,

lep.type_of_company,

(select flex_active.flex_value_set_name

FROM FND_DESCR_FLEX_COLUMN_USAGES col_usage,

FND_FLEX_VALUE_SETS flex_active

WHERE col_usage.application_id = 204

AND col_usage.descriptive_flexfield_name = 'XLE_LE_INFO_DEV'

AND lep.le_information_context = col_usage.descriptive_flex_context_code

AND col_usage.application_column_name = 'ACTIVITY_CODE'

AND col_usage.flex_value_set_id = flex_active.flex_value_set_id ) Activity_Category,

(SELECT lkp.meaning

FROM ar_lookups lkp

WHERE lkp.lookup_type = (select flex_active.flex_value_set_name

FROM FND_DESCR_FLEX_COLUMN_USAGES col_usage,

FND_FLEX_VALUE_SETS flex_active

WHERE col_usage.application_id = 204

AND col_usage.descriptive_flexfield_name = 'XLE_LE_INFO_DEV'

AND lep.le_information_context = col_usage.descriptive_flex_context_code

AND col_usage.application_column_name = 'ACTIVITY_CODE'

AND col_usage.flex_value_set_id = flex_active.flex_value_set_id )

AND lkp.lookup_code = lep.activity_code) Activity_description,

LEP.effective_from le_effective_from,

LEP.effective_to le_effective_to,

LEP.ATTRIBUTE_CATEGORY,

LEP.ATTRIBUTE1,

LEP.ATTRIBUTE2,

LEP.ATTRIBUTE3,

LEP.ATTRIBUTE4,

LEP.ATTRIBUTE5,

LEP.ATTRIBUTE6,

LEP.ATTRIBUTE7,

LEP.ATTRIBUTE8,

LEP.ATTRIBUTE9,

LEP.ATTRIBUTE10,

LEP.ATTRIBUTE11,

LEP.ATTRIBUTE12,

LEP.ATTRIBUTE13,

LEP.ATTRIBUTE14,

LEP.ATTRIBUTE15,

LEP.ATTRIBUTE16,

LEP.ATTRIBUTE17,

LEP.ATTRIBUTE18,

LEP.ATTRIBUTE19,

LEP.ATTRIBUTE20,

LEP.ATTRIBUTE_NUMBER1,

LEP.ATTRIBUTE_NUMBER2,

LEP.ATTRIBUTE_NUMBER3,

LEP.ATTRIBUTE_NUMBER4,

LEP.ATTRIBUTE_NUMBER5,

LEP.ATTRIBUTE_DATE1,

LEP.ATTRIBUTE_DATE2,

LEP.ATTRIBUTE_DATE3,

LEP.ATTRIBUTE_DATE4,

LEP.ATTRIBUTE_DATE5,

reg.registration_number,

jur.legislative_cat_code legislative_cat_code,

reg.effective_from,

reg.effective_to,

reg.location_id,

hrl.style ADDRESS_STYLE,

hrl.address_line_1,

hrl.address_line_2,

hrl.address_line_3,

hrl.town_or_city,

hrl.region_1,

hrl.region_2,

hrl.region_3,

hrl.postal_code,

hrl.country

FROM XLE_ENTITY_PROFILES lep,

XLE_REGISTRATIONS reg,

XLE_JURISDICTIONS_B jur,

XLE_LOCATIONS_V hrl

WHERE

lep.transacting_entity_flag = 'Y'

AND lep.legal_entity_id = reg.source_id

AND reg.source_table = 'XLE_ENTITY_PROFILES'

AND reg.identifying_flag = 'Y'

AND jur.jurisdiction_id = reg.jurisdiction_id

AND hrl.location_id = reg.location_id