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

TABLE: DPP.DPP_CUSTOMER_CLAIMS_ALL

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


This table will store the customer inventory & claim information for a Price Protection Transaction.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DPP_CUSTOMER_CLAIMS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_INV_LINE_ID
DPP_CUSTOMER_CLAIMS_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_HEADER_ID
ColumnLINE_NUMBER
DPP_CUSTOMER_CLAIMS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
DPP_CUSTOMER_CLAIMS_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_HEADER_ID
ColumnINVENTORY_ITEM_ID
ColumnCUST_ACCOUNT_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
SUPPLIER_PRICE_DROP NUMBER

Change Value for the Item provded by the Supplier.
TRANSACTION_HEADER_ID NUMBER
Yes Unique identifier for the PP Transaction
CUSTOMER_INV_LINE_ID NUMBER
Yes Customer Inventory detail line ID
LINE_NUMBER NUMBER
Yes Customer Inventory detail line number
CUST_ACCOUNT_ID VARCHAR2 (150) Yes Customer Account ID
INVENTORY_ITEM_ID VARCHAR2 (150) Yes Inventory Item ID
LAST_PRICE NUMBER

Last Price for the product for a customer
SUPPLIER_NEW_PRICE NUMBER

New Price for the item provided by supplier
CUSTOMER_NEW_PRICE NUMBER

New Price for the product for a customer decided by the distributor
TRX_CURRENCY VARCHAR2 (15)
Transactional Currency
REPORTED_INVENTORY NUMBER

Inventory reported by the customer
CALCULATED_INVENTORY NUMBER

Inventory calculated by the application for a customer
UOM VARCHAR2 (3)
Unit Of Measure
CUST_CLAIM_AMT NUMBER

Customer Claim Amount
SUPP_CLAIM_AMT NUMBER

Supplier Claim for Customer Amount
DEBIT_MEMO_NUMBER VARCHAR2 (30)
Debit Memo Number from customer
CUSTOMER_CLAIM_ID VARCHAR2 (150)
Customer Claim ID
SUPP_CUST_CLAIM_ID VARCHAR2 (150)
Supplier Claim for Customer ID
ORG_ID VARCHAR2 (150)
Operating Unit
CUSTOMER_CLAIM_CREATED VARCHAR2 (1) Yes Customer Claim creation status: Y/N
SUPPLIER_CLAIM_CREATED VARCHAR2 (1) Yes Supplier Claim for Customer creation status: Y/N
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 (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
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 SUPPLIER_PRICE_DROP
,      TRANSACTION_HEADER_ID
,      CUSTOMER_INV_LINE_ID
,      LINE_NUMBER
,      CUST_ACCOUNT_ID
,      INVENTORY_ITEM_ID
,      LAST_PRICE
,      SUPPLIER_NEW_PRICE
,      CUSTOMER_NEW_PRICE
,      TRX_CURRENCY
,      REPORTED_INVENTORY
,      CALCULATED_INVENTORY
,      UOM
,      CUST_CLAIM_AMT
,      SUPP_CLAIM_AMT
,      DEBIT_MEMO_NUMBER
,      CUSTOMER_CLAIM_ID
,      SUPP_CUST_CLAIM_ID
,      ORG_ID
,      CUSTOMER_CLAIM_CREATED
,      SUPPLIER_CLAIM_CREATED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      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_CUSTOMER_CLAIMS_ALL;

Dependencies

[top of page]

DPP.DPP_CUSTOMER_CLAIMS_ALL does not reference any database object

DPP.DPP_CUSTOMER_CLAIMS_ALL is referenced by following:

SchemaDPP
ViewDPP_CUSTOMER_CLAIMS_ALL#