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

TABLE: OZF.OZF_RESALE_ADJUSTMENTS_ALL

Object Details
Object Name: OZF_RESALE_ADJUSTMENTS_ALL
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_RESALE_ADJUSTMENTS_ALL
Subobject Name:
Status: VALID


OZF_CHARGEBACK_PRICE_ADJ_ALL STORES PRICE ADJUSTMENT INFO FOR A THIRD PARTY ORDER.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_RESALE_ADJUSTMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESALE_ADJUSTMENT_ID
OZF_RESALE_ADJUSTMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESALE_LINE_ID
OZF_RESALE_ADJUSTMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESALE_BATCH_ID
OZF_RESALE_ADJUSTMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_AGREEMENT_NAME
OZF_RESALE_ADJUSTMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_AGREEMENT_UOM
Columns
Name Datatype Length Mandatory Comments
RESALE_ADJUSTMENT_ID NUMBER
Yes Unique identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control when using HTML as a user interface
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
REQUEST_ID NUMBER

Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATED_FROM VARCHAR2 (30)
Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
PROGRAM_APPLICATION_ID NUMBER

Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
PROGRAM_ID NUMBER

Standard WHO Column
RESALE_BATCH_ID NUMBER
Yes Resale Batch Identifier
STATUS_CODE VARCHAR2 (30)
Status Code
RESALE_LINE_ID NUMBER
Yes Resale Line Identifier
ORIG_SYSTEM_AGREEMENT_UOM VARCHAR2 (240)
Origin System Agreement Unit of Measurement
ORIG_SYSTEM_AGREEMENT_NAME VARCHAR2 (240)
Origin System Agreement Name
ORIG_SYSTEM_AGREEMENT_TYPE VARCHAR2 (30)
Origin System Agreement Type
ORIG_SYSTEM_AGREEMENT_STATUS VARCHAR2 (30)
Origin System Agreement Status
ORIG_SYSTEM_AGREEMENT_CURR VARCHAR2 (15)
Origin System Agreement Currency
ORIG_SYSTEM_AGREEMENT_PRICE NUMBER

Origin System Agreement Price
ORIG_SYSTEM_AGREEMENT_QUANTITY NUMBER

Origin System Agreement Quantity
AGREEMENT_ID NUMBER

Agreement Identifier
AGREEMENT_TYPE VARCHAR2 (30)
Agreement Type
AGREEMENT_NAME VARCHAR2 (240)
Agreement Name
AGREEMENT_PRICE NUMBER

Agreement Price
AGREEMENT_UOM_CODE VARCHAR2 (3)
Agreement Unit of Measurement Code
CORRECTED_AGREEMENT_ID NUMBER

Corrected Agreement Identifier
CORRECTED_AGREEMENT_NAME VARCHAR2 (240)
Corrected Agreement Name
CREDIT_CODE VARCHAR2 (30)
Credit Code
CREDIT_ADVICE_DATE DATE

Credit Advice Date
CLAIMED_AMOUNT NUMBER

Unit Claimed Amount
TOTAL_CLAIMED_AMOUNT NUMBER

Total Claimed Amount
ALLOWED_AMOUNT NUMBER

Allowed Amount
TOTAL_ALLOWED_AMOUNT NUMBER

Total Allowed Amount
ACCEPTED_AMOUNT NUMBER

Accepted Amount
TOTAL_ACCEPTED_AMOUNT NUMBER

Total Accepted Amount
CALCULATED_PRICE NUMBER

Calculated Price
ACCTD_CALCULATED_PRICE NUMBER

Accounted Calculated Price
CALCULATED_AMOUNT NUMBER

Calculated Amount
LINE_AGREEMENT_FLAG VARCHAR2 (1)
Line Agreement Indicator
TOLERANCE_FLAG VARCHAR2 (1)
Tolerance Indicator
LINE_TOLERANCE_AMOUNT NUMBER

Line Tolerance Amount
OPERAND NUMBER

Operand
OPERAND_CALCULATION_CODE VARCHAR2 (30)
Operand Calculation Code
PRICED_QUANTITY NUMBER

Priced Quantity
PRICED_UOM_CODE VARCHAR2 (3)
Priced Unit of Measurement
PRICED_UNIT_PRICE NUMBER

Unit price of an item in Price List
LIST_HEADER_ID NUMBER

Qp List Header Identifier
LIST_LINE_ID NUMBER

Qp List Line Identifier
ORG_ID NUMBER

Organization identifier
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT RESALE_ADJUSTMENT_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATED_FROM
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      RESALE_BATCH_ID
,      STATUS_CODE
,      RESALE_LINE_ID
,      ORIG_SYSTEM_AGREEMENT_UOM
,      ORIG_SYSTEM_AGREEMENT_NAME
,      ORIG_SYSTEM_AGREEMENT_TYPE
,      ORIG_SYSTEM_AGREEMENT_STATUS
,      ORIG_SYSTEM_AGREEMENT_CURR
,      ORIG_SYSTEM_AGREEMENT_PRICE
,      ORIG_SYSTEM_AGREEMENT_QUANTITY
,      AGREEMENT_ID
,      AGREEMENT_TYPE
,      AGREEMENT_NAME
,      AGREEMENT_PRICE
,      AGREEMENT_UOM_CODE
,      CORRECTED_AGREEMENT_ID
,      CORRECTED_AGREEMENT_NAME
,      CREDIT_CODE
,      CREDIT_ADVICE_DATE
,      CLAIMED_AMOUNT
,      TOTAL_CLAIMED_AMOUNT
,      ALLOWED_AMOUNT
,      TOTAL_ALLOWED_AMOUNT
,      ACCEPTED_AMOUNT
,      TOTAL_ACCEPTED_AMOUNT
,      CALCULATED_PRICE
,      ACCTD_CALCULATED_PRICE
,      CALCULATED_AMOUNT
,      LINE_AGREEMENT_FLAG
,      TOLERANCE_FLAG
,      LINE_TOLERANCE_AMOUNT
,      OPERAND
,      OPERAND_CALCULATION_CODE
,      PRICED_QUANTITY
,      PRICED_UOM_CODE
,      PRICED_UNIT_PRICE
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      ORG_ID
,      SECURITY_GROUP_ID
FROM OZF.OZF_RESALE_ADJUSTMENTS_ALL;

Dependencies

[top of page]

OZF.OZF_RESALE_ADJUSTMENTS_ALL does not reference any database object

OZF.OZF_RESALE_ADJUSTMENTS_ALL is referenced by following:

SchemaOZF
ViewOZF_RESALE_ADJUSTMENTS_ALL#