[Home] [Help]
View: IBY_PP_FIRST_PARTY_V
View Text
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.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
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 |