VIEW: APPS.IBY_PP_FIRST_PARTY_V

Source

View Text - Preformatted

SELECT le_info.party_id, party.party_number, party.party_name, le_info.legal_entity_id, le_info.name, party.tax_name, party.party_type, null, null, le_info.registration_number, le_info.address_line_1, le_info.address_line_2, null, le_info.town_or_city, null, le_info.region_1, le_info.country, le_info.postal_code, null, null, null, null FROM xle_firstparty_information_v le_info, hz_parties party WHERE le_info.party_id = party.party_id

View Text - HTML Formatted

SELECT LE_INFO.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, LE_INFO.LEGAL_ENTITY_ID
, LE_INFO.NAME
, PARTY.TAX_NAME
, PARTY.PARTY_TYPE
, NULL
, NULL
, LE_INFO.REGISTRATION_NUMBER
, LE_INFO.ADDRESS_LINE_1
, LE_INFO.ADDRESS_LINE_2
, NULL
, LE_INFO.TOWN_OR_CITY
, NULL
, LE_INFO.REGION_1
, LE_INFO.COUNTRY
, LE_INFO.POSTAL_CODE
, NULL
, NULL
, NULL
, NULL
FROM XLE_FIRSTPARTY_INFORMATION_V LE_INFO
, HZ_PARTIES PARTY
WHERE LE_INFO.PARTY_ID = PARTY.PARTY_ID