IBY_PP_FIRST_PARTY_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
PARTY_ID PARTY_NUMBER PARTY_NAME PARTY_LEGAL_ID PARTY_LEGAL_NAME PARTY_TAX_ID PARTY_TYPE_CODE PARTY_TYPE PARTY_ADDRESS_ID PARTY_ADDRESS_LINE1 PARTY_ADDRESS_LINE2 PARTY_ADDRESS_LINE3 PARTY_ADDRESS_CITY PARTY_ADDRESS_COUNTY PARTY_ADDRESS_STATE PARTY_ADDRESS_COUNTRY PARTY_ADDRESS_POSTAL_CODE PARTY_PHONE PARTY_FAX PARTY_EMAIL PARTY_WEBSITE

Query

SQL_Statement

SELECT le_info.party_id PARTY_ID, party.party_number PARTY_NUMBER, party.party_name PARTY_NAME, le_info.legal_entity_id PARTY_LEGAL_ID, le_info.name PARTY_LEGAL_NAME, taxprofile.rep_registration_number PARTY_TAX_ID, party.party_type PARTY_TYPE_CODE, NULL PARTY_TYPE, NULL PARTY_ADDRESS_ID, le_info.address_line_1 PARTY_ADDRESS_LINE1, le_info.address_line_2 PARTY_ADDRESS_LINE2, NULL PARTY_ADDRESS_LINE3, le_info.town_or_city PARTY_ADDRESS_CITY, NULL PARTY_ADDRESS_COUNTY, le_info.region_1 PARTY_ADDRESS_STATE, le_info.country PARTY_ADDRESS_COUNTRY, le_info.postal_code PARTY_ADDRESS_POSTAL_CODE, NULL PARTY_PHONE, NULL PARTY_FAX, NULL PARTY_EMAIL, NULL PARTY_WEBSITE FROM xle_firstparty_information_v le_info, hz_parties party, zx_party_tax_profile taxprofile WHERE le_info.party_id = party.party_id and taxprofile.party_id = party.party_id and taxprofile.party_type_code = 'FIRST_PARTY'