DBA Data[Home] [Help]

VIEW: APPS.IBY_EXT_FD_PAYER_1_0_VD

Source

View Text - Preformatted

SELECT payer_party_id, payer_party_number, payer_legal_entity_name, null, null, payer_tax_registration_num, payer_le_registration_num, payer_party_attr_category, legal_entity_id, payer_legal_entity_name, payer_location_id, payer_le_attr_category, payer_party_site_name, payment_id FROM iby_payments_all
View Text - HTML Formatted

SELECT PAYER_PARTY_ID
, PAYER_PARTY_NUMBER
, PAYER_LEGAL_ENTITY_NAME
, NULL
, NULL
, PAYER_TAX_REGISTRATION_NUM
, PAYER_LE_REGISTRATION_NUM
, PAYER_PARTY_ATTR_CATEGORY
, LEGAL_ENTITY_ID
, PAYER_LEGAL_ENTITY_NAME
, PAYER_LOCATION_ID
, PAYER_LE_ATTR_CATEGORY
, PAYER_PARTY_SITE_NAME
, PAYMENT_ID
FROM IBY_PAYMENTS_ALL