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

TABLE: OZF.OZF_RESALE_BATCHES_ALL

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


OZF_RESALE_BATCHES_ALL stores the batches for resale that are grouped with similar reasons


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_RESALE_BATCHES_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESALE_BATCH_ID
OZF_RESALE_BATCHES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_NUMBER
OZF_RESALE_BATCHES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_DATE
OZF_RESALE_BATCHES_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTNER_CUST_ACCOUNT_ID
OZF_RESALE_BATCHES_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTNER_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
RESALE_BATCH_ID NUMBER
Yes Unique identifier
OBJECT_VERSION_NUMBER NUMBER (9) 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
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
REQUEST_ID NUMBER

Standard WHO Column
CREATED_FROM VARCHAR2 (30)
Created From
PROGRAM_APPLICATION_ID NUMBER

Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
PROGRAM_ID NUMBER

Standard WHO Column
BATCH_TYPE VARCHAR2 (30)
Batch Type such as Chargeback, Ship and Debit or Tracing
BATCH_NUMBER VARCHAR2 (30)
Batch Number
BATCH_COUNT NUMBER

Total Line Items
YEAR NUMBER

Year
MONTH NUMBER

Month
REPORT_DATE DATE

Report Date
REPORT_START_DATE DATE

Report Start Date
REPORT_END_DATE DATE

Report End Date
STATUS_CODE VARCHAR2 (30)
Claim batch status
DATA_SOURCE_CODE VARCHAR2 (30)
Data Source Identifier
REFERENCE_TYPE VARCHAR2 (30)
Reference Code for additional information
REFERENCE_NUMBER VARCHAR2 (30)
Reference Number
COMMENTS VARCHAR2 (800)
Claim batch description
PARTNER_CLAIM_NUMBER VARCHAR2 (30)
Claim Number specified by Trading Partner
TRANSACTION_PURPOSE_CODE VARCHAR2 (30)
Transaction Purpose Code
TRANSACTION_TYPE_CODE VARCHAR2 (30)
Type of document
ORG_ID NUMBER

Organization identifier
PARTNER_TYPE VARCHAR2 (30)
Type of Party ( for distributor, warehouse )
PARTNER_ID NUMBER

Relationship Identifier between Partner and Manufacturer
PARTNER_PARTY_ID NUMBER

Party Identifier for Trading Partner
PARTNER_CUST_ACCOUNT_ID NUMBER

Account Identifier for Party
PARTNER_SITE_ID NUMBER

Site Identifier for Party's Address
PARTNER_CONTACT_PARTY_ID NUMBER

Relationship Identifier between Partner Contact and Partner
PARTNER_CONTACT_NAME VARCHAR2 (360)
Party Contact Name
PARTNER_EMAIL VARCHAR2 (2000)
Partner Email Address
PARTNER_PHONE VARCHAR2 (60)
Partner Phone
PARTNER_FAX VARCHAR2 (60)
Partner Fax
HEADER_TOLERANCE_OPERAND NUMBER

Header Tolerance Amount or Percent Value
HEADER_TOLERANCE_CALC_CODE VARCHAR2 (30)
Header Tolerance % or Amount
LINE_TOLERANCE_OPERAND NUMBER

Line Tolerance Amount or Percent Value
LINE_TOLERANCE_CALC_CODE VARCHAR2 (30)
Line Tolerance % or Amount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CLAIMED_AMOUNT NUMBER

Claimed Amount
ALLOWED_AMOUNT NUMBER

Allowed Amount
ACCEPTED_AMOUNT NUMBER

Accepted Amount
PAID_AMOUNT NUMBER

Paid Amount
DISPUTED_AMOUNT NUMBER

Disputed Amount
LINES_INVALID NUMBER

Lines Invalid
LINES_W_TOLERANCE NUMBER

Lines with Tolerance
LINES_DISPUTED NUMBER

Lines Disputed
BATCH_SET_ID_CODE VARCHAR2 (30)
Identifies the source of data ( WebADI, XML or Other
CREDIT_CODE VARCHAR2 (30)
Credit/Debit Identifier
CREDIT_ADVICE_DATE DATE

Credit Advice Date
PURGE_FLAG VARCHAR2 (1)
Batch Purge Status Indicator
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SECURITY_GROUP_ID NUMBER

Used in hosted environments
DIRECT_ORDER_FLAG VARCHAR2 (1)
Direct Order Flag
Query Text

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


SELECT RESALE_BATCH_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      CREATED_FROM
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      BATCH_TYPE
,      BATCH_NUMBER
,      BATCH_COUNT
,      YEAR
,      MONTH
,      REPORT_DATE
,      REPORT_START_DATE
,      REPORT_END_DATE
,      STATUS_CODE
,      DATA_SOURCE_CODE
,      REFERENCE_TYPE
,      REFERENCE_NUMBER
,      COMMENTS
,      PARTNER_CLAIM_NUMBER
,      TRANSACTION_PURPOSE_CODE
,      TRANSACTION_TYPE_CODE
,      ORG_ID
,      PARTNER_TYPE
,      PARTNER_ID
,      PARTNER_PARTY_ID
,      PARTNER_CUST_ACCOUNT_ID
,      PARTNER_SITE_ID
,      PARTNER_CONTACT_PARTY_ID
,      PARTNER_CONTACT_NAME
,      PARTNER_EMAIL
,      PARTNER_PHONE
,      PARTNER_FAX
,      HEADER_TOLERANCE_OPERAND
,      HEADER_TOLERANCE_CALC_CODE
,      LINE_TOLERANCE_OPERAND
,      LINE_TOLERANCE_CALC_CODE
,      CURRENCY_CODE
,      CLAIMED_AMOUNT
,      ALLOWED_AMOUNT
,      ACCEPTED_AMOUNT
,      PAID_AMOUNT
,      DISPUTED_AMOUNT
,      LINES_INVALID
,      LINES_W_TOLERANCE
,      LINES_DISPUTED
,      BATCH_SET_ID_CODE
,      CREDIT_CODE
,      CREDIT_ADVICE_DATE
,      PURGE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      DIRECT_ORDER_FLAG
FROM OZF.OZF_RESALE_BATCHES_ALL;

Dependencies

[top of page]

OZF.OZF_RESALE_BATCHES_ALL does not reference any database object

OZF.OZF_RESALE_BATCHES_ALL is referenced by following:

SchemaOZF
ViewOZF_RESALE_BATCHES_ALL#