[Home] [Help]
View: IBY_EXT_FD_PAYER_1_0_V
View Text
SELECT PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, PARTY_TYPE_LOOKUP.MEANING
, IBY_FD_EXTRACT_GEN_PVT.GET_FP_TAXREGISTRATION(XLE_FIRSTPARTY.LEGAL_ENTITY_ID)
, XLE_FIRSTPARTY.REGISTRATION_NUMBER
, PARTY.ATTRIBUTE_CATEGORY
, XLE_FIRSTPARTY.LEGAL_ENTITY_ID
, XLE_FIRSTPARTY.NAME
, XLE_FIRSTPARTY.LOCATION_ID
, XLE_FIRSTPARTY.ATTRIBUTE_CATEGORY
FROM XLE_FIRSTPARTY_INFORMATION_V XLE_FIRSTPARTY
, HZ_PARTIES PARTY
, AR_LOOKUPS PARTY_TYPE_LOOKUP
WHERE XLE_FIRSTPARTY.PARTY_ID = PARTY.PARTY_ID
AND PARTY.PARTY_TYPE = PARTY_TYPE_LOOKUP.LOOKUP_CODE
AND PARTY_TYPE_LOOKUP.LOOKUP_TYPE = 'PARTY_TYPE'
Columns
Name |
PARTY_ID |
PARTY_NUMBER |
PARTY_NAME |
PARTY_TYPE |
PARTY_TYPE_MEANING |
TAX_REGISTRATION_NUMBER |
LE_REGISTRATION_NUMBER |
PARTY_ATTR_CAT |
LEGAL_ENTITY_ID |
LEGAL_ENTITY_NAME |
LE_LOCATION_ID |
LE_ATTR_CAT |