eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IBY_EXT_FD_INVPAYEE_1_0_VD

Object Details

Object Name:	IBY_EXT_FD_INVPAYEE_1_0_VD
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

"This view fetches consolidated attributes to be populated under 'Trading partner' tag under the 'OutboundPayment' tag of the XML extract for the funds disbursements.
IBY_EXT_FD_INVPAYEE_1_0_VD view is built on IBY_PAYMENTS_ALL AND IBY_EXTERNAL_PAYEES_ALL tables. "

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_ID	NUMBER	(15)	Yes	Payment Identifier
PARTY_ID	NUMBER	(15)		Party (trading partner) identifier.
VENDOR_ID	NUMBER	(15)		Supplier (Trading Partner) identifier
VENDOR_SITE_ID	NUMBER	(15)		Supplier Site Identifier
SUPPLIER_NUMBER	VARCHAR2	(30)		Supplier (Trading Partner) Number.
PARTY_NUMBER	VARCHAR2	(30)		Party (trading party) number
PARTY_NAME	VARCHAR2	(360)		Payee Party Name
ALTERNATE_NAME	VARCHAR2	(320)		Party (trading partner) alternate name
SITE_NAME	VARCHAR2	(150)		Supplier (Trading Partner) site name
ALTERNATE_SITE_NAME	VARCHAR2	(320)		Supplier (Trading Partner) site alternative name
PARTY_TYPE	VARCHAR2	(0)		Party Type
PARTY_TYPE_MEANING	VARCHAR2	(0)		Party Type Meaning
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)		Tax registration number of the Party (trading partner)
LE_REGISTRATION_NUMBER	VARCHAR2	(50)		Legal registration number of the Party (trading partner)
PARTY_ATTR_CAT	VARCHAR2	(150)		Payee party category.
PAYMENT_LOCATION_ID	VARCHAR2	(0)		Payment Location ID
CUSTOMER_NUM	VARCHAR2	(30)		Party (trading partner) reference
PARTY_SITE_ID	NUMBER	(15)		Party Site Identifier
PAYEE_SUPPLIER_ATTR_CATEGORY	VARCHAR2	(150)		Supplier (Trading Partner) attribute category
PAYEE_SPPLR_SITE_ATTR_CATEGORY	VARCHAR2	(150)		Supplier (Trading Partner) site attribute category
REMIT_ADVICE_DELIVERY_METHOD	VARCHAR2	(30)		Default delivery method for the Separate remittance advice report. The value can be set at Payee or payee site level also. If the override with Payee delivery option is checked in the Payment process profile, the setting at the payee and payee site level will be ignored. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINT
REMIT_ADVICE_EMAIL	VARCHAR2	(255)		E-mail address at which the payee wishes to receive remittance advice
REMIT_ADVICE_FAX	VARCHAR2	(100)		Fax number at which the payee wishes to receive remittance advice
ADDITIONAL_INFORMATION	VARCHAR2	(4000)		Additional information for the third party payment relationship.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYMENT_ID
,      PARTY_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      SUPPLIER_NUMBER
,      PARTY_NUMBER
,      PARTY_NAME
,      ALTERNATE_NAME
,      SITE_NAME
,      ALTERNATE_SITE_NAME
,      PARTY_TYPE
,      PARTY_TYPE_MEANING
,      TAX_REGISTRATION_NUMBER
,      LE_REGISTRATION_NUMBER
,      PARTY_ATTR_CAT
,      PAYMENT_LOCATION_ID
,      CUSTOMER_NUM
,      PARTY_SITE_ID
,      PAYEE_SUPPLIER_ATTR_CATEGORY
,      PAYEE_SPPLR_SITE_ATTR_CATEGORY
,      REMIT_ADVICE_DELIVERY_METHOD
,      REMIT_ADVICE_EMAIL
,      REMIT_ADVICE_FAX
,      ADDITIONAL_INFORMATION
FROM APPS.IBY_EXT_FD_INVPAYEE_1_0_VD;

Dependencies

[top of page]

APPS.IBY_EXT_FD_INVPAYEE_1_0_VD references the following:

APPS: IBY_EXTERNAL_PAYEES_ALL; IBY_FD_EXTRACT_GEN_PVT - show dependent code; IBY_PAYMENTS_ALL

APPS.IBY_EXT_FD_INVPAYEE_1_0_VD is referenced by following:

APPS: IBY_XML_FD_INVPAYEE_1_0_V