IBY_EXT_FC_PAYEE_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

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

Query

SQL_Statement

SELECT party.party_id party_id, party.party_number party_number, party.party_name party_name, party.party_type party_type, NULL PARTY_TYPE_MEANING, iby_fd_extract_gen_pvt.Get_FP_TaxRegistration(xle_firstparty.legal_entity_id) TAX_REGISTRATION_NUMBER, xle_firstparty.registration_number LE_REGISTRATION_NUMBER, party.attribute_category PARTY_ATTR_CAT, xle_firstparty.legal_entity_id legal_entity_id, xle_firstparty.name LEGAL_ENTITY_NAME, xle_firstparty.location_id LE_LOCATION_ID, xle_firstparty.attribute_category LE_ATTR_CAT FROM xle_firstparty_information_v xle_firstparty, hz_parties party WHERE xle_firstparty.party_id = party.party_id