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


TYPE: APPS.POS_SUPPLIER_CONTACT_BO

Object Details
Object Name: POS_SUPPLIER_CONTACT_BO
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
VENDOR_CONTACT_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

VENDOR_SITE_ID NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

INACTIVE_DATE DATE

FIRST_NAME VARCHAR2 (15)
MIDDLE_NAME VARCHAR2 (15)
LAST_NAME VARCHAR2 (20)
PREFIX VARCHAR2 (5)
TITLE VARCHAR2 (30)
MAIL_STOP VARCHAR2 (35)
AREA_CODE VARCHAR2 (10)
PHONE VARCHAR2 (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

CONTACT_NAME_ALT VARCHAR2 (320)
FIRST_NAME_ALT VARCHAR2 (230)
LAST_NAME_ALT VARCHAR2 (230)
DEPARTMENT VARCHAR2 (230)
EMAIL_ADDRESS VARCHAR2 (2000)
URL VARCHAR2 (2000)
ALT_AREA_CODE VARCHAR2 (10)
ALT_PHONE VARCHAR2 (15)
FAX_AREA_CODE VARCHAR2 (10)
FAX VARCHAR2 (15)
PER_PARTY_ID NUMBER
15
PER_ORIG_SYSTEM VARCHAR2 (30)
PER_ORIG_SYSTEM_REF VARCHAR2 (255)
RELATIONSHIP_ID NUMBER
15
REL_PARTY_ID NUMBER
15
PARTY_SITE_ID NUMBER
15
ORG_CONTACT_ID NUMBER
15
ORG_PARTY_SITE_ID NUMBER
15
PARTY_SITE_NAME VARCHAR2 (240)
CONTACT_NAME_PHONETIC VARCHAR2 (320)
OPERATING_UNIT_NAME VARCHAR2 (240)
VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_CONTACT_INTERFACE_ID NUMBER

VENDOR_ID NUMBER

VENDOR_INTERFACE_ID NUMBER

ORG_ID NUMBER

ORGANIZATION_NAME_PHONETIC VARCHAR2 (320)
PARTY_NUMBER VARCHAR2 (30)

Dependencies

[top of page]

APPS.POS_SUPPLIER_CONTACT_BO references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.POS_SUPPLIER_CONTACT_BO is referenced by following:

SchemaAPPS
Package BodyPOS_SUPPLIER_CONTACT_BO_PKG - show dependent code
TYPEPOS_SUPPLIER_CONTACT_BO_TBL