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

TABLE: DPP.DPP_TXN_HEADERS_INT_ALL

Object Details
Object Name: DPP_TXN_HEADERS_INT_ALL
Object Type: TABLE
Owner: DPP
FND Design Data: TableDPP.DPP_TXN_HEADERS_INT_ALL
Subobject Name:
Status: VALID


This interface table will store the Price Protection Transaction header level details received from the supplier.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DPP_TXN_HEADERS_INT_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_INT_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
ORIG_SYS_DOCUMENT_REF VARCHAR2 (40)
System document reference
TRANSACTION_INT_HEADER_ID NUMBER
Yes Unique identifier for the interface Transaction header
REF_DOCUMENT_NUMBER VARCHAR2 (40)
To track internal approval details. Provided by the supplier.
EFFECTIVE_START_DATE DATE

The date from which the Price Protection Transaction will be valid
DAYS_COVERED NUMBER

Number of days covered as per the Price protection Transaction
ORG_ID VARCHAR2 (150)
Operating Unit
OPERATING_UNIT_NAME VARCHAR2 (240)
Operating Unit Name
VENDOR_NAME VARCHAR2 (240)
Supplier Name
VENDOR_ID VARCHAR2 (150)
Supplier ID
VENDOR_SITE VARCHAR2 (15)
Supplier Site Code
VENDOR_SITE_ID VARCHAR2 (150)
Unique Identifier for the supplier's site
VENDOR_CONTACT_NAME VARCHAR2 (50)
Supplier contact name
VENDOR_CONTACT_ID VARCHAR2 (150)
Supplier Contact ID
CONTACT_EMAIL_ADDRESS VARCHAR2 (2000)
Supplier contact persons email.
CONTACT_PHONE VARCHAR2 (40)
Supplier contact persons phone.
CURRENCY VARCHAR2 (15)
Transactional currency
SUPP_DIST_CLAIM_ID VARCHAR2 (150)
Supplier Claim for Distributor Claim ID
SUPP_DIST_CLAIM_NUMBER VARCHAR2 (150)
Supplier Claim for Distributor Claim Number
SUPPLIER_APPROVED_BY VARCHAR2 (100)
Supplier pre-approver name
SUPPLIER_APPROVAL_DATE DATE

Date of Supplier Pre-Approval
TRANSACTION_SOURCE VARCHAR2 (40)
Transaction Source: WebADI, XML, Script
INTERFACE_STATUS VARCHAR2 (1) Yes Interface Record Status
ERROR_CODE VARCHAR2 (30)
Error Code.
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
REQUEST_ID NUMBER

Standard WHO Column
PROGRAM_APPLICATION_ID NUMBER

Standard WHO Column
PROGRAM_ID NUMBER

Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
Query Text

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


SELECT ORIG_SYS_DOCUMENT_REF
,      TRANSACTION_INT_HEADER_ID
,      REF_DOCUMENT_NUMBER
,      EFFECTIVE_START_DATE
,      DAYS_COVERED
,      ORG_ID
,      OPERATING_UNIT_NAME
,      VENDOR_NAME
,      VENDOR_ID
,      VENDOR_SITE
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_NAME
,      VENDOR_CONTACT_ID
,      CONTACT_EMAIL_ADDRESS
,      CONTACT_PHONE
,      CURRENCY
,      SUPP_DIST_CLAIM_ID
,      SUPP_DIST_CLAIM_NUMBER
,      SUPPLIER_APPROVED_BY
,      SUPPLIER_APPROVAL_DATE
,      TRANSACTION_SOURCE
,      INTERFACE_STATUS
,      ERROR_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM DPP.DPP_TXN_HEADERS_INT_ALL;

Dependencies

[top of page]

DPP.DPP_TXN_HEADERS_INT_ALL does not reference any database object

DPP.DPP_TXN_HEADERS_INT_ALL is referenced by following:

SchemaDPP
ViewDPP_TXN_HEADERS_INT_ALL#