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

TABLE: AP.AP_SUP_SITE_CONTACT_INT

Object Details
Object Name: AP_SUP_SITE_CONTACT_INT
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_SUP_SITE_CONTACT_INT
Subobject Name:
Status: VALID


AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when the Supplier Sites Open Interface Import program is submitted.
Each row in the table will be joined to the appropriate Supplier Site using the VENDOR_SITE_CODE
and ORG_ID.
This is the open interface table for AP Supplier Site Contacts. Use it in conjunction with AP_SUPPLIERS_SITES_INT.
Scope: public
Product: AP
Lifecycle: active
Display Name: AP Supplier Site Contacts Interface
Category: BUSINESS_ENTITY AP_SUPPLIER_CONTACT


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
VENDOR_SITE_ID NUMBER

Supplier Site unique identifier
VENDOR_SITE_CODE VARCHAR2 (15)
Site Name
ORG_ID NUMBER (15)
Operating unit unique identifier
OPERATING_UNIT_NAME VARCHAR2 (240)
Operating Unit name
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
INACTIVE_DATE DATE

Inactive date for record
FIRST_NAME VARCHAR2 (15)
Contact First name
MIDDLE_NAME VARCHAR2 (15)
Contact middle name
LAST_NAME VARCHAR2 (60)
Contact last name
PREFIX VARCHAR2 (30)
Prefix
TITLE VARCHAR2 (30)
Title
MAIL_STOP VARCHAR2 (35)
Contact mail stop
AREA_CODE VARCHAR2 (10)
Area code of contact phone number
PHONE VARCHAR2 (40)
Contact phone number
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
REQUEST_ID NUMBER

Enhanced Who column
CONTACT_NAME_ALT VARCHAR2 (320)
Alternate supplier contact name
FIRST_NAME_ALT VARCHAR2 (230)
Alternate Supplier contact first name
LAST_NAME_ALT VARCHAR2 (230)
Alternate Supplier contact last name
DEPARTMENT VARCHAR2 (230)
Department
IMPORT_REQUEST_ID NUMBER (15)
Concurrent Who column
STATUS VARCHAR2 (30)
Status of the data in or after the import
REJECT_CODE VARCHAR2 (2000)
Supplier rejection reason
EMAIL_ADDRESS VARCHAR2 (2000)
Email address for the Supplier Site contact.
URL VARCHAR2 (2000)
URL for the Supplier Site contact.
ALT_AREA_CODE VARCHAR2 (10)
Area code for the alternate telephone number for the Supplier Site contact.
ALT_PHONE VARCHAR2 (15)
Alternate telephone number for the Supplier Site contact.
FAX_AREA_CODE VARCHAR2 (10)
Area code of the facsimile number for the Supplier Site contact.
FAX VARCHAR2 (40)
Facsimile number for the Supplier Site contact.
VENDOR_INTERFACE_ID NUMBER (15)
Supplier interface record unique identifier
VENDOR_ID NUMBER (15)
Supplier unique identifier
VENDOR_CONTACT_INTERFACE_ID NUMBER (15) Yes Vendor Contact Interface Identifier
PARTY_SITE_ID NUMBER (15)
Party Site Unique Identifier
PARTY_SITE_NAME VARCHAR2 (240)
Party site name from TCA party site table
PARTY_ORIG_SYSTEM VARCHAR2 (240)
This column is for future use
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 (255)
This column is for future use
PARTY_SITE_ORIG_SYSTEM VARCHAR2 (30)
This column is for future use
PARTY_SITE_ORIG_SYS_REFERENCE VARCHAR2 (255)
This column is for future use
SUPPLIER_SITE_ORIG_SYSTEM VARCHAR2 (30)
This column is for future use
SUP_SITE_ORIG_SYSTEM_REFERENCE VARCHAR2 (255)
This column is for future use
CONTACT_ORIG_SYSTEM VARCHAR2 (30)
This column is for future use
CONTACT_ORIG_SYSTEM_REFERENCE VARCHAR2 (255)
This column is for future use
SDH_BATCH_ID NUMBER (15)
This column is for future use
PARTY_ID NUMBER (15)
This column is for future use
PER_PARTY_ID NUMBER (15)
This column is for future use
REL_PARTY_ID NUMBER (15)
This column is for future use
RELATIONSHIP_ID NUMBER (15)
This column is for future use
ORG_CONTACT_ID NUMBER (15)
This column is for future use
Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      ORG_ID
,      OPERATING_UNIT_NAME
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      INACTIVE_DATE
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      TITLE
,      MAIL_STOP
,      AREA_CODE
,      PHONE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CONTACT_NAME_ALT
,      FIRST_NAME_ALT
,      LAST_NAME_ALT
,      DEPARTMENT
,      IMPORT_REQUEST_ID
,      STATUS
,      REJECT_CODE
,      EMAIL_ADDRESS
,      URL
,      ALT_AREA_CODE
,      ALT_PHONE
,      FAX_AREA_CODE
,      FAX
,      VENDOR_INTERFACE_ID
,      VENDOR_ID
,      VENDOR_CONTACT_INTERFACE_ID
,      PARTY_SITE_ID
,      PARTY_SITE_NAME
,      PARTY_ORIG_SYSTEM
,      PARTY_ORIG_SYSTEM_REFERENCE
,      PARTY_SITE_ORIG_SYSTEM
,      PARTY_SITE_ORIG_SYS_REFERENCE
,      SUPPLIER_SITE_ORIG_SYSTEM
,      SUP_SITE_ORIG_SYSTEM_REFERENCE
,      CONTACT_ORIG_SYSTEM
,      CONTACT_ORIG_SYSTEM_REFERENCE
,      SDH_BATCH_ID
,      PARTY_ID
,      PER_PARTY_ID
,      REL_PARTY_ID
,      RELATIONSHIP_ID
,      ORG_CONTACT_ID
FROM AP.AP_SUP_SITE_CONTACT_INT;

Dependencies

[top of page]

AP.AP_SUP_SITE_CONTACT_INT does not reference any database object

AP.AP_SUP_SITE_CONTACT_INT is referenced by following:

SchemaAP
ViewAP_SUP_SITE_CONTACT_INT#