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


This is the open interface table for importing supplier site contacts from external sources. It can be used in conjuction with AP_SUPPLIERS_INT & AP_SUPPLIER_SITES_INT or separately to import supplier site contacts. The columns in this table maps to corresponding columns in TCA tables and AP_SUPPLIER_CONTACTS table. PO_VENDOR_CONTACTS view provides complete view of contacts. 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.
Please refer to the Oracle Payables Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
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 - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
VENDOR_SITE_ID NUMBER

Unique identifier for the supplier site. This column is used to join the contact to the appropriate supplier site. A value must be provided for this column or for the VENDOR_SITE_CODE and either ORG_ID or OPERATING_UNIT_NAME.This column is validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID during import.
VENDOR_SITE_CODE VARCHAR2 (15)
Supplier Site name. This column is used to join the contact to the appropriate supplier site. A value must be provided for this column along with either ORG_ID or OPERATING_UNIT_NAME if no value is present for VENDOR_SITE_ID.This column is validated against AP_SUPPLIER_SITES_INT.VENDOR_SITE_CODE during import
ORG_ID NUMBER (15)
Unique internal identifier of the Operating Unit to which the contact to be imported. A value is required for this column or OPERATING_UNIT_NAME column, along with the VENDOR_SITE_ID or the VENDOR_SITE_CODE column. These values are used during the import process to join the contact with the proper supplier site. If both 'ID' and 'NAME' are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.Additionally, a check will be done to confirm that the VENDOR_SITE_CODE/ORG_ID combination is also valid.This column is validated against HR_OPERATING_UNITS.ORGANIZATION_ID, as well asPO_VENDOR_SITES_ALL.VENDOR_SITE_CODE and PO_VENDOR_SITES_ALL.ORG_ID during import
OPERATING_UNIT_NAME VARCHAR2 (240)
Operating Unit name to which the contact to be imported. Required if value is not provided for ORG_ID column, along with the VENDOR_SITE_ID or the VENDOR_SITE_CODE column. These values are used during the import process to join the contact with the proper supplier site. If both 'ID' and 'NAME' are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.Additionally, a check will be done to confirm that the VENDOR_SITE_CODE/ORG_ID combination is also valid.This column is validated against HR_OPERATING_UNITS.ORGANIZATION_ID, as well as PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE and PO_VENDOR_SITES_ALL.ORG_ID during import"
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
INACTIVE_DATE DATE

The date on which the contact is no longer valid. Must be entered in valid date format
FIRST_NAME VARCHAR2 (15)
First name of the supplier contact.
MIDDLE_NAME VARCHAR2 (15)
Middle name of the supplier contact
LAST_NAME VARCHAR2 (20)
Last name of the supplier contact
PREFIX VARCHAR2 (5)
Prefix for the supplier contact (For example Mr., Mrs., etc.)
TITLE VARCHAR2 (30)
Title for the supplier contact
MAIL_STOP VARCHAR2 (35)
Contact mail stop
AREA_CODE VARCHAR2 (10)
Area code for the phone number of the supplier contact.
PHONE VARCHAR2 (15)
Phone number of the supplier contact
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table.
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table.
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table..
CONTACT_NAME_ALT VARCHAR2 (320)
Alternate name for the contact for the supplier site. This column is designed for entering both Kanji and Kana values.
FIRST_NAME_ALT VARCHAR2 (230)
Alternate first name for the contact for the supplier site. This column is designed for entering both Kanji and Kana values.
LAST_NAME_ALT VARCHAR2 (230)
Alternate last name for the contact for the supplier site. This column is designed for entering both Kanji and Kana values.
DEPARTMENT VARCHAR2 (230)
Department of the supplier contact
IMPORT_REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table..
STATUS VARCHAR2 (30)
Indicates the status of the record in the interface table. Initial value of this column should be provided as 'NEW'. After the Supplier Site Contacts Open Interface Import program is run, successfully imported records will be marked as 'PROCESSED' and records that are not imported will be marked 'REJECTED'.
REJECT_CODE VARCHAR2 (2000)
Indicates the reason the record has been rejected by the Supplier Site Contacts Open Interface Import Program. This column is populated by the Supplier Sites Open Interface Import Program and should not be populated.
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 (15)
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 Supplier Contact Interface Identifier to be entered for a supplier contact record to be imported
PARTY_SITE_ID NUMBER (15)
Party site unique identifier from TCA party site table
PARTY_SITE_NAME VARCHAR2 (240)
Party site name from TCA party site table
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
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:

SchemaAPPS
SynonymAP_SUP_SITE_CONTACT_INT