[Home] [Help]
[Dependency Information]
| Object Name: | PO_VENDOR_CONTACTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | SQLAP.PO_VENDOR_CONTACTS
|
| Subobject Name: | |
| Status: | VALID |
| 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 |
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;
APPS
AP_SUPPLIERS
AP_SUPPLIER_CONTACTS
AP_SUPPLIER_SITES_ALL
HZ_CONTACT_POINTS
HZ_ORG_CONTACTS
HZ_PARTIES
HZ_PARTY_SITES
HZ_RELATIONSHIPS
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
|
|
|
|