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

TABLE: DPP.DPP_TRANSACTION_LINES_LOG

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


This table will store history information for the Price Protection Transaction Line level details.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DPP_TRANSACTION_LINES_LOG_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOG_ID
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes Lead Log Identifier
LOG_MODE VARCHAR2 (1)
Log mode
TRANSACTION_LINE_ID NUMBER

Unique identifier for the PP Transaction Line
SUPPLIER_PART_NUM VARCHAR2 (240)
Supplier Part Number
INVENTORY_ITEM_ID VARCHAR2 (150)
Inventory Item ID
PRIOR_PRICE NUMBER

The price for which the product was purchased from supplier.
CHANGE_TYPE VARCHAR2 (30)
Increase Amount, Increase Percentage, New Price, Decrease Amount, Decrease Percentage
CHANGE_VALUE NUMBER

Change Value
ONHAND_INVENTORY NUMBER

On-hand Inventory calculated from ERP application
COVERED_INVENTORY NUMBER

Covered Inventory calculated from ERP application
APPROVED_INVENTORY NUMBER

Inventory approved by supplier to be covered under the Price protection Transaction.
CLAIM_AMOUNT NUMBER

Claim Amount
MANUALLY_ADJUSTED VARCHAR2 (1)
Manually Adjusted Status Y/N
UPDATE_PURCHASING_DOCS VARCHAR2 (1)
Purchasing Documents Updation Status Y/N
NOTIFY_PURCHASING_DOCS VARCHAR2 (1)
Purchasing Documents Notification Status Y/N
UPDATE_INVENTORY_COSTING VARCHAR2 (1)
Inventory costing Updation Status Y/N
UPDATE_ITEM_LIST_PRICE VARCHAR2 (1)
Item List Price Updation Status Y/N
NOTIFY_INBOUND_PRICELIST VARCHAR2 (1)
Inbound Price List Notification Status Y/N
NOTIFY_OUTBOUND_PRICELIST VARCHAR2 (1)
Outbound Price List Notification Status Y/N
NOTIFY_PROMOTIONS_PRICELIST VARCHAR2 (1)
Promotions Notification Status Y/N
SUPP_DIST_CLAIM_STATUS VARCHAR2 (1)
Supplier Claim for Distributor creation status Y/N
ORG_ID VARCHAR2 (150)
Operating Unit
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
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 LOG_ID
,      LOG_MODE
,      TRANSACTION_LINE_ID
,      SUPPLIER_PART_NUM
,      INVENTORY_ITEM_ID
,      PRIOR_PRICE
,      CHANGE_TYPE
,      CHANGE_VALUE
,      ONHAND_INVENTORY
,      COVERED_INVENTORY
,      APPROVED_INVENTORY
,      CLAIM_AMOUNT
,      MANUALLY_ADJUSTED
,      UPDATE_PURCHASING_DOCS
,      NOTIFY_PURCHASING_DOCS
,      UPDATE_INVENTORY_COSTING
,      UPDATE_ITEM_LIST_PRICE
,      NOTIFY_INBOUND_PRICELIST
,      NOTIFY_OUTBOUND_PRICELIST
,      NOTIFY_PROMOTIONS_PRICELIST
,      SUPP_DIST_CLAIM_STATUS
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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_TRANSACTION_LINES_LOG;

Dependencies

[top of page]

DPP.DPP_TRANSACTION_LINES_LOG does not reference any database object

DPP.DPP_TRANSACTION_LINES_LOG is referenced by following:

SchemaDPP
ViewDPP_TRANSACTION_LINES_LOG#