[Home] [Help] [Dependency Information]
Object Name: | IBY_EXT_FD_PAYEE_1_0_VD |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | (150) | ||
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) |
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
FROM APPS.IBY_EXT_FD_PAYEE_1_0_VD;
|
|
|