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

***** 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 Comments
PAYMENT_ID NUMBER (15) Yes Payment Identifier
PARTY_ID NUMBER (22)
Party (trading partner) identifier
VENDOR_ID NUMBER (22)
Supplier (Trading Partner) identifier
VENDOR_SITE_ID NUMBER (22)
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 (22)
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
PAYEE_COUNTRY VARCHAR2 (60)
Payee country code
REMIT_TO_LOCATION_ID NUMBER (15)
Remit-To address identifier
PMT_PARTY_SITE_ID NUMBER (15)
Party Site identifier
PMT_PAYEE_PARTY_ID NUMBER (15)
TCA party identifier
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
,      PAYEE_COUNTRY
,      REMIT_TO_LOCATION_ID
,      PMT_PARTY_SITE_ID
,      PMT_PAYEE_PARTY_ID
FROM APPS.IBY_EXT_FD_INVPAYEE_1_0_VD;

Dependencies

[top of page]

APPS.IBY_EXT_FD_INVPAYEE_1_0_VD references the following:

SchemaAPPS
SynonymIBY_EXTERNAL_PAYEES_ALL
PL/SQL PackageIBY_FD_EXTRACT_GEN_PVT - show dependent code
SynonymIBY_PAYMENTS_ALL
APPS.IBY_EXT_FD_INVPAYEE_1_0_VD is referenced by following:

SchemaAPPS
ViewIBY_XML_FD_INVPAYEE_1_0_V