[Home] [Help]
[Dependency Information]
VIEW: APPS.PO_VENDOR_CONTACTS
Object Details
Object Name: | PO_VENDOR_CONTACTS |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | SQLAP.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 |
(31) |
|
|
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:
-
APPS
-
AP_SUPPLIERS
-
AP_SUPPLIER_CONTACTS
-
AP_SUPPLIER_SITES_ALL
-
HZ_CONTACT_POINTS
-
HZ_ORG_CONTACTS
-
HZ_PARTIES
-
HZ_PARTY_SITES
-
HZ_RELATIONSHIPS
APPS.PO_VENDOR_CONTACTS is referenced by following:
-
APPS
-
AHL_OSP_ORDERS_PVT
- show dependent code
-
AHL_OSP_ORDERS_V
-
AHL_OSP_PO_PVT
- show dependent code
-
AHL_OSP_PO_REQ_PVT
- show dependent code
-
AHL_VENDOR_CERTIFICATIONS_V
-
AP_APXINAGE_XMLP_PKG
- show dependent code
-
AP_SUPPLIER_INFO_PKG
- show dependent code
-
AP_SUPPLIER_INFO_PKG
- show dependent code
-
AP_VENDOR_PUB_PKG
- show dependent code
-
CAC_NOTES_PVT
- show dependent code
-
CN_PAYRUN_PVT
- show dependent code
-
CSI_INSTANCE_PARTIES_VLD_PVT
- show dependent code
-
CSI_PARTY_CONTACT_DETAILS_V
-
CSI_PARTY_RELATIONSHIPS_PVT
- show dependent code
-
CSI_T_PARTY_CONTACTS_V
-
DPP_UTILITY_PVT
- show dependent code
-
EAM_WORK_ORDER_DIRECT_ITEMS_V
-
EAM_WORK_ORDER_REQ_PO_V
-
ECE_POCO_HEADERS_V
-
ECE_POO_HEADERS_V
-
FUN_CONTACTUS_EMAIL
- show dependent code
-
GMF_AP_GET_VENDOR_CONTACTS
- show dependent code
-
IBU_DYN_USER_GROUPS_PKG
- show dependent code
-
ICX_EDM_PO_BLANKET_REL_V
-
ICX_EDM_PURCHASE_ORDER_V
-
ICX_POR_SEARCH_CONTRACTS_V
-
ICX_PO_HDR_ARCHIVE_OPEN_V
-
ICX_PO_HEADERS_ARCHIVE_V
-
ICX_PO_LATE_RECEIPTS_V
-
ICX_PO_REQUISITION_TEMPLATES_V
-
ICX_PO_REQ_TEMPLATE_ITEMS_V
-
ICX_PO_RFQ_HEADERS_V
-
ICX_PO_SUPPLIER_AGREEMENTS_V
-
ICX_PO_SUPPLIER_CATALOGS_V
-
ICX_PO_SUPPLIER_ORDERS_V
-
ICX_PO_SUPPL_CATALOG_ITEMS_V
-
ICX_PO_SUPPL_CAT_ITEMS_V
-
ICX_PO_SUPPL_SEARCH_ITEMS_V
-
ICX_PO_VENDOR_CONTACTS_V
-
ICX_REQ_TEMPLATES
- show dependent code
-
ICX_SUPPLIER_ACCOUNT_V
-
ICX_SUPPLIER_CONTACT_LOV
-
ICX_SUPPLIER_SAV_DEFAULTS_V
-
ICX_SUPP_CUSTOM
- show dependent code
-
IGCFV_CC_CONTRACT_COMMITMENTS
-
IGCFV_CC_RELEASES
-
IGC_CC_COMMON_UTILS_PVT
- show dependent code
-
IGC_CC_HEADERS_V
-
IGC_CC_OPEN_INTERFACE_PKG
- show dependent code
-
IGC_CC_OPN_UPD_GET_LNK_PUB
- show dependent code
-
ITG_PO_HEADER_ARCH_V
-
ITG_REQ_VENDOR_CONTACTS_V
-
ITG_SP_PO_PART_SUPPL_V
-
ITG_SP_REL_PART_SUPPL_V
-
ITG_UPDEL_HEADERS_V
-
JA_CN_COA_EXP_PKG
- show dependent code
-
JE_JEHUIAGE_XMLP_PKG
- show dependent code
-
JMF_SHIKYU_RPT_CFR_PVT
- show dependent code
-
JMF_SHIKYU_RPT_SPR_PVT
- show dependent code
-
JTF_RS_CONC_RES_PUB
- show dependent code
-
JTF_RS_SUPPLIERS_VL
-
JTF_RS_WF_INTEGRATION_PUB
- show dependent code
-
MRP_EXP_WF
- show dependent code
-
OKC_REP_QA_CHECK_PVT
- show dependent code
-
OKC_REP_UTIL_PVT
- show dependent code
-
OKL_CS_VENDOR_CONTACTS_UV
-
OKL_CURE_HEADER_UV
-
OKL_CURE_VENDOR_SUMRY_UV
-
OKL_REQ_WF
- show dependent code
-
OKS_ENTITLEMENTS_PVT
- show dependent code
-
OKS_ENTITLEMENTS_WEB
- show dependent code
-
OKS_IB_UTIL_PVT
- show dependent code
-
OKX_RESOURCES_V
-
OKX_VENDOR_CONTACTS_V
-
OTA_VENDOR_CONTACTS_V
-
OZF_SD_BATCH_PVT
- show dependent code
-
OZF_SD_REQUEST_PUB
- show dependent code
-
PJM_INQUIRY
- show dependent code
-
POBV_SUPPLIER_CONTACTS
-
POFV_BKT_PURCHASE_ORDERS
-
POFV_PLAN_PURCHASE_ORDERS
-
POFV_PURCHASE_CONTRACTS
-
POFV_PURCHASE_ORDERS
-
POFV_QUOTATIONS
-
POFV_REQUESTS_FOR_QUOTATION
-
POFV_RFQ_SUPPLIERS
-
POFV_RFQ_SUPPLIER_LIST_ENTRIES
-
POFV_STD_PURCHASE_ORDERS
-
POFV_SUPPLIER_CONTACTS
-
POR_CONTRACTOR_NOTIFY
- show dependent code
-
POR_SUPPLIER_LOV_V
-
POS_ACK_SEARCH
- show dependent code
-
POS_COMPARE_REVISIONS
- show dependent code
-
POS_PO_DETAILS_V
-
POS_PO_EXPECTED_RECEIPTS_V
-
POS_PO_HEADERS_ARCHIVE_V
-
POS_PO_INVOICE_SUP_ORDERS_V
-
POS_PO_LATE_RECEIPTS_V
-
POS_PO_LINES_ARCHIVE_V
-
POS_PO_LINES_V
-
POS_PO_RFQ_HEADERS_V
-
POS_PO_SUPPLIER_AGREEMENTS_V
-
POS_PO_SUPPLIER_ORDERS_V
-
POS_SUPP_CUSTOM
- show dependent code
-
POS_VENDOR_UTIL_PKG
- show dependent code
-
PO_AUTOCREATE_DOC
- show dependent code
-
PO_AUTOSOURCE_SV
- show dependent code
-
PO_COMPARE_REVISIONS
- show dependent code
-
PO_COPYDOC_SUB
- show dependent code
-
PO_CXML_HEADER_ARCH_V
-
PO_DOCUMENT_CHECKS_PVT
- show dependent code
-
PO_ECX_HEADER_ARCH_V
-
PO_EMAIL_GENERATE
- show dependent code
-
PO_HEADERS_ARCHIVE_XML
-
PO_HEADERS_INQ_PO_V
-
PO_HEADERS_INQ_REL_V
-
PO_HEADERS_INQ_V
-
PO_HEADERS_PRINT
-
PO_HEADERS_RFQQT_V
-
PO_HEADERS_V
-
PO_HEADERS_XML
-
PO_LINES_INQ_V
-
PO_LINE_LOCATIONS_INQ_V
-
PO_NEGOTIATED_SOURCES_V
-
PO_OTM_INTEGRATION_PVT
- show dependent code
-
PO_PDOI_HEADER_PROCESS_PVT
- show dependent code
-
PO_PURCHASE_HISTORY_V
-
PO_R12_CAT_UPG_DEF_PVT
- show dependent code
-
PO_R12_CAT_UPG_VAL_PVT
- show dependent code
-
PO_RELEASES_V
-
PO_RELEASE_ARCHIVE_XML
-
PO_RELEASE_XML
-
PO_REQEXPRESS_LINES_V
-
PO_REQUISITION_TEMPLATES_V
-
PO_REQ_TEMPLATE_SV2
- show dependent code
-
PO_REQ_TEMPLATE_SV3
- show dependent code
-
PO_RFQ_HEADERS_PRINT
-
PO_RFQ_VENDORS_V
-
PO_SIGNATURE_PVT
- show dependent code
-
PO_SUPPLIER_CONTACTS_VAL_V
-
PO_VAL_HEADERS2
- show dependent code
-
PO_VENDORS_PVT
- show dependent code
-
PO_VENDORS_SV1
- show dependent code
-
PO_VENDOR_CONTACTS_DFV
-
PO_VENDOR_CONTACTS_SV
- show dependent code
-
PO_VENDOR_LIST_ENTRIES_V
-
PO_VENDOR_SITES_SV
- show dependent code
-
QA_SS_IMPORT_WF
- show dependent code