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_PAYEE_1_0_VD

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
PAYMENT_ID	NUMBER	(15)	Yes
PARTY_ID	NUMBER	(15)
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER	(15)
SUPPLIER_NUMBER	VARCHAR2	(30)
PARTY_NUMBER	VARCHAR2	(30)
PARTY_NAME	VARCHAR2	(360)
ALTERNATE_NAME	VARCHAR2	(320)
SITE_NAME	VARCHAR2	(240)
ALTERNATE_SITE_NAME	VARCHAR2	(320)
PARTY_TYPE	VARCHAR2	(0)
PARTY_TYPE_MEANING	VARCHAR2	(0)
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)
LE_REGISTRATION_NUMBER	VARCHAR2	(50)
PARTY_ATTR_CAT	VARCHAR2	(150)
PAYMENT_LOCATION_ID	NUMBER	(15)
CUSTOMER_NUM	VARCHAR2	(30)
PARTY_SITE_ID	NUMBER	(15)
PAYEE_SUPPLIER_ATTR_CATEGORY	VARCHAR2	(150)
PAYEE_SPPLR_SITE_ATTR_CATEGORY	VARCHAR2	(150)
REMIT_ADVICE_DELIVERY_METHOD	VARCHAR2	(30)
REMIT_ADVICE_EMAIL	VARCHAR2	(255)
REMIT_ADVICE_FAX	VARCHAR2	(100)
PAYEE_ADDRESSEE	VARCHAR2	(360)
EMPLOYEE_PAYMENT_FLAG	VARCHAR2	(1)
EMPLOYEE_ADDRESS_ID	NUMBER	(15)
PAYEE_ADDRESS1	VARCHAR2	(240)
PAYEE_ADDRESS2	VARCHAR2	(240)
PAYEE_ADDRESS3	VARCHAR2	(240)
PAYEE_ADDRESS4	VARCHAR2	(240)
PAYEE_CITY	VARCHAR2	(60)
PAYEE_COUNTY	VARCHAR2	(120)
PAYEE_STATE	VARCHAR2	(120)
PAYEE_PROVINCE	VARCHAR2	(120)
PAYEE_COUNTRY	VARCHAR2	(60)
PAYEE_POSTAL_CODE	VARCHAR2	(60)
PAYEE_ADDRESS_CONCAT	VARCHAR2	(2000)
ADDRESS_NAME	VARCHAR2	(360)

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
,      PAYEE_ADDRESSEE
,      EMPLOYEE_PAYMENT_FLAG
,      EMPLOYEE_ADDRESS_ID
,      PAYEE_ADDRESS1
,      PAYEE_ADDRESS2
,      PAYEE_ADDRESS3
,      PAYEE_ADDRESS4
,      PAYEE_CITY
,      PAYEE_COUNTY
,      PAYEE_STATE
,      PAYEE_PROVINCE
,      PAYEE_COUNTRY
,      PAYEE_POSTAL_CODE
,      PAYEE_ADDRESS_CONCAT
,      ADDRESS_NAME
FROM APPS.IBY_EXT_FD_PAYEE_1_0_VD;

Dependencies

[top of page]

APPS.IBY_EXT_FD_PAYEE_1_0_VD references the following:

APPS: IBY_EXTERNAL_PAYEES_ALL; IBY_PAYMENTS_ALL

APPS.IBY_EXT_FD_PAYEE_1_0_VD is referenced by following:

APPS: IBY_XML_FD_PAYEEM_1_0_V; IBY_XML_FD_PAYEE_1_0_V