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


VIEW: APPS.PO_VENDOR_CONTACTS

Object Details
Object Name: PO_VENDOR_CONTACTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.PO_VENDOR_CONTACTS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
VENDOR_CONTACT_ID NUMBER

VENDOR_SITE_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

FIRST_NAME VARCHAR2 (15)
MIDDLE_NAME VARCHAR2 (15)
LAST_NAME VARCHAR2 (15)
PREFIX VARCHAR2 (60)
TITLE VARCHAR2 (30)
MAIL_STOP VARCHAR2 (60)
AREA_CODE VARCHAR2 (10)
PHONE VARCHAR2 (40)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

CONTACT_NAME_ALT VARCHAR2 (320)
FIRST_NAME_ALT VARCHAR2 (60)
LAST_NAME_ALT VARCHAR2 (60)
DEPARTMENT VARCHAR2 (60)
EMAIL_ADDRESS VARCHAR2 (2000)
URL VARCHAR2 (2000)
ALT_AREA_CODE VARCHAR2 (10)
ALT_PHONE VARCHAR2 (40)
FAX_AREA_CODE VARCHAR2 (10)
FAX VARCHAR2 (40)
INACTIVE_DATE DATE

PER_PARTY_ID NUMBER (15)
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)
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)
VENDOR_ID NUMBER

Query Text

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


SELECT VENDOR_CONTACT_ID
,      VENDOR_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      TITLE
,      MAIL_STOP
,      AREA_CODE
,      PHONE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTACT_NAME_ALT
,      FIRST_NAME_ALT
,      LAST_NAME_ALT
,      DEPARTMENT
,      EMAIL_ADDRESS
,      URL
,      ALT_AREA_CODE
,      ALT_PHONE
,      FAX_AREA_CODE
,      FAX
,      INACTIVE_DATE
,      PER_PARTY_ID
,      RELATIONSHIP_ID
,      REL_PARTY_ID
,      PARTY_SITE_ID
,      ORG_CONTACT_ID
,      ORG_PARTY_SITE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENDOR_ID
FROM APPS.PO_VENDOR_CONTACTS;

Dependencies

[top of page]

APPS.PO_VENDOR_CONTACTS references the following:

SchemaAPPS
SynonymAP_SUPPLIERS
SynonymAP_SUPPLIER_CONTACTS
SynonymAP_SUPPLIER_SITES_ALL
SynonymHZ_CONTACT_POINTS
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
APPS.PO_VENDOR_CONTACTS is referenced by following:

SchemaAPPS
Package BodyAHL_OSP_ORDERS_PVT - show dependent code
ViewAHL_OSP_ORDERS_V
Package BodyAHL_OSP_PO_PVT - show dependent code
Package BodyAHL_OSP_PO_REQ_PVT - show dependent code
Package BodyAP_APXINAGE_XMLP_PKG - show dependent code
PL/SQL PackageAP_SUPPLIER_INFO_PKG - show dependent code
Package BodyAP_SUPPLIER_INFO_PKG - show dependent code
Package BodyAP_VENDOR_PUB_PKG - show dependent code
Package BodyCAC_NOTES_PVT - show dependent code
Package BodyCN_PAYRUN_PVT - show dependent code
Package BodyCSI_INSTANCE_PARTIES_VLD_PVT - show dependent code
ViewCSI_PARTY_CONTACT_DETAILS_V
Package BodyCSI_PARTY_RELATIONSHIPS_PVT - show dependent code
ViewCSI_T_PARTY_CONTACTS_V
Package BodyDPP_UTILITY_PVT - show dependent code
ViewEAM_WORK_ORDER_DIRECT_ITEMS_V
ViewEAM_WORK_ORDER_REQ_PO_V
ViewECE_POCO_HEADERS_V
ViewECE_POO_HEADERS_V
Package BodyFUN_CONTACTUS_EMAIL - show dependent code
Package BodyFUN_XML_REPORT_PKG - show dependent code
Package BodyGMF_AP_GET_VENDOR_CONTACTS - show dependent code
Package BodyIBU_DYN_USER_GROUPS_PKG - show dependent code
ViewICX_EDM_PO_BLANKET_REL_V
ViewICX_EDM_PURCHASE_ORDER_V
ViewICX_POR_SEARCH_CONTRACTS_V
ViewICX_PO_HDR_ARCHIVE_OPEN_V
ViewICX_PO_HEADERS_ARCHIVE_V
ViewICX_PO_LATE_RECEIPTS_V
ViewICX_PO_REQUISITION_TEMPLATES_V
ViewICX_PO_REQ_TEMPLATE_ITEMS_V
ViewICX_PO_RFQ_HEADERS_V
ViewICX_PO_SUPPLIER_AGREEMENTS_V
ViewICX_PO_SUPPLIER_CATALOGS_V
ViewICX_PO_SUPPLIER_ORDERS_V
ViewICX_PO_SUPPL_CATALOG_ITEMS_V
ViewICX_PO_SUPPL_CAT_ITEMS_V
ViewICX_PO_SUPPL_SEARCH_ITEMS_V
ViewICX_PO_VENDOR_CONTACTS_V
Package BodyICX_REQ_TEMPLATES - show dependent code
ViewICX_SUPPLIER_ACCOUNT_V
ViewICX_SUPPLIER_CONTACT_LOV
ViewICX_SUPPLIER_SAV_DEFAULTS_V
Package BodyICX_SUPP_CUSTOM - show dependent code
ViewIGCFV_CC_CONTRACT_COMMITMENTS
ViewIGCFV_CC_RELEASES
Package BodyIGC_CC_COMMON_UTILS_PVT - show dependent code
ViewIGC_CC_HEADERS_V
Package BodyIGC_CC_OPEN_INTERFACE_PKG - show dependent code
Package BodyIGC_CC_OPN_UPD_GET_LNK_PUB - show dependent code
ViewITG_PO_HEADER_ARCH_V
ViewITG_REQ_VENDOR_CONTACTS_V
ViewITG_SP_PO_PART_SUPPL_V
ViewITG_SP_REL_PART_SUPPL_V
ViewITG_UPDEL_HEADERS_V
Package BodyJA_CN_COA_EXP_PKG - show dependent code
Package BodyJE_JEHUIAGE_XMLP_PKG - show dependent code
Package BodyJMF_SHIKYU_RPT_CFR_PVT - show dependent code
Package BodyJMF_SHIKYU_RPT_SPR_PVT - show dependent code
Package BodyJTF_RS_CONC_RES_PUB - show dependent code
ViewJTF_RS_SUPPLIERS_VL
Package BodyJTF_RS_WF_INTEGRATION_PUB - show dependent code
Package BodyMRP_EXP_WF - show dependent code
Package BodyOKC_REP_QA_CHECK_PVT - show dependent code
Package BodyOKC_REP_SIGN_WF_PVT - show dependent code
Package BodyOKC_REP_UTIL_PVT - show dependent code
ViewOKL_CS_VENDOR_CONTACTS_UV
ViewOKL_CURE_HEADER_UV
ViewOKL_CURE_VENDOR_SUMRY_UV
Package BodyOKL_REQ_WF - show dependent code
Package BodyOKS_ENTITLEMENTS_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
Package BodyOKS_IB_UTIL_PVT - show dependent code
ViewOKX_RESOURCES_V
ViewOKX_VENDOR_CONTACTS_V
ViewOTA_VENDOR_CONTACTS_V
Package BodyOZF_SD_BATCH_PVT - show dependent code
Package BodyOZF_SD_REQUEST_PUB - show dependent code
Package BodyPJM_INQUIRY - show dependent code
ViewPOBV_SUPPLIER_CONTACTS
ViewPOFV_BKT_PURCHASE_ORDERS
ViewPOFV_PLAN_PURCHASE_ORDERS
ViewPOFV_PURCHASE_CONTRACTS
ViewPOFV_PURCHASE_ORDERS
ViewPOFV_QUOTATIONS
ViewPOFV_REQUESTS_FOR_QUOTATION
ViewPOFV_RFQ_SUPPLIERS
ViewPOFV_RFQ_SUPPLIER_LIST_ENTRIES
ViewPOFV_STD_PURCHASE_ORDERS
ViewPOFV_SUPPLIER_CONTACTS
Package BodyPON_AUCTION_CREATE_PO_PKG - show dependent code
Package BodyPOR_CONTRACTOR_NOTIFY - show dependent code
ViewPOR_SUPPLIER_LOV_V
Package BodyPOS_ACK_SEARCH - show dependent code
Package BodyPOS_COMPARE_REVISIONS - show dependent code
ViewPOS_PO_DETAILS_V
ViewPOS_PO_EXPECTED_RECEIPTS_V
ViewPOS_PO_HEADERS_ARCHIVE_V
ViewPOS_PO_INVOICE_SUP_ORDERS_V
ViewPOS_PO_LATE_RECEIPTS_V
ViewPOS_PO_LINES_ARCHIVE_V
ViewPOS_PO_LINES_V
ViewPOS_PO_RFQ_HEADERS_V
ViewPOS_PO_SUPPLIER_AGREEMENTS_V
ViewPOS_PO_SUPPLIER_ORDERS_V
Package BodyPOS_SUPP_CUSTOM - show dependent code
Package BodyPOS_VENDOR_UTIL_PKG - show dependent code
Package BodyPO_AUTOCREATE_DOC - show dependent code
Package BodyPO_AUTOSOURCE_SV - show dependent code
Package BodyPO_CHANGEORDERWF_PVT - show dependent code
Package BodyPO_CLOSEOUT_PVT - show dependent code
Package BodyPO_COMPARE_REVISIONS - show dependent code
Package BodyPO_COPYDOC_SUB - show dependent code
ViewPO_CXML_HEADER_ARCH_V
ViewPO_ECX_HEADER_ARCH_V
Package BodyPO_EMAIL_GENERATE - show dependent code
Package BodyPO_FED_FIELD_FUNCTIONS - show dependent code
ViewPO_HEADERS_ARCHIVE_XML
ViewPO_HEADERS_INQ_PO_V
ViewPO_HEADERS_INQ_V
ViewPO_HEADERS_PRINT
ViewPO_HEADERS_RFQQT_V
ViewPO_HEADERS_V
ViewPO_HEADERS_XML
ViewPO_LINES_INQ_V
ViewPO_LINE_LOCATIONS_INQ_V
Package BodyPO_MULTI_MOD_PVT - show dependent code
Package BodyPO_OTM_INTEGRATION_PVT - show dependent code
Package BodyPO_PDOI_HEADER_PROCESS_PVT - show dependent code
ViewPO_PURCHASE_HISTORY_V
Package BodyPO_R12_CAT_UPG_DEF_PVT - show dependent code
Package BodyPO_R12_CAT_UPG_VAL_PVT - show dependent code
Package BodyPO_RCO_VALIDATION_PVT - show dependent code
ViewPO_RELEASES_V
ViewPO_RELEASE_ARCHIVE_XML
ViewPO_RELEASE_XML
ViewPO_REQEXPRESS_LINES_V
ViewPO_REQUISITION_TEMPLATES_V
Package BodyPO_REQ_TEMPLATE_SV2 - show dependent code
Package BodyPO_REQ_TEMPLATE_SV3 - show dependent code
ViewPO_RFQ_HEADERS_PRINT
ViewPO_RFQ_VENDORS_V
Package BodyPO_SIGNATURE_PVT - show dependent code
ViewPO_SUPPLIER_CONTACTS_VAL_V
Package BodyPO_VAL_HEADERS2 - show dependent code
Package BodyPO_VENDORS_PVT - show dependent code
Package BodyPO_VENDORS_SV1 - show dependent code
ViewPO_VENDOR_CONTACTS_DFV
Package BodyPO_VENDOR_CONTACTS_SV - show dependent code
ViewPO_VENDOR_LIST_ENTRIES_V
Package BodyPO_VENDOR_SITES_SV - show dependent code
Package BodyQA_SS_IMPORT_WF - show dependent code