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]

TABLE: AP.AP_SUP_SITE_CONTACT_INT

Object Details

Object Name:	AP_SUP_SITE_CONTACT_INT
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.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:	APPS_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:

APPS: AP_SUP_SITE_CONTACT_INT