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

VIEW: APPS.OZF_RESALE_WEBADI_DOWNLOAD_V

Object Details
Object Name: OZF_RESALE_WEBADI_DOWNLOAD_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

[View Source]

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
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
BATCH_TYPE VARCHAR2 (30)
Transaction Set Purpose Code
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_END_DATE DATE

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)
TRANSACTION_PURPOSE_CODE VARCHAR2 (30)
TRANSACTION_TYPE_CODE VARCHAR2 (30)
Type of document
PARTNER_TYPE VARCHAR2 (30)
Type of Party ( for distributor, warehouse )
PARTNER_PARTY_ID NUMBER

PARTNER_CUST_ACCOUNT_ID NUMBER

Account ID for Party
PARTNER_SITE_ID NUMBER

DUNS Number of Party
PARTNER_CONTACT_PARTY_ID NUMBER

Site Use ID of Party
PARTNER_CONTACT_NAME VARCHAR2 (360)
Party Contact Name
PARTNER_EMAIL VARCHAR2 (2000)
Party Contact Number
PARTNER_PHONE VARCHAR2 (60)
PARTNER_FAX VARCHAR2 (60)
BATCH_CURRENCY_CODE VARCHAR2 (15)
Currency Code
BATCH_CLAIMED_AMOUNT NUMBER

BATCH_CREDIT_CODE VARCHAR2 (30)
Credit/Debit Flag
BATCH_CREDIT_ADVICE_DATE DATE

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
RESALE_LINE_INT_ID NUMBER
Yes primay key of the table
RESALE_TRANSFER_TYPE VARCHAR2 (30)
PRODUCT_TRANSFER_MOVEMENT_TYPE VARCHAR2 (30)
Type identifying the sender and receiver of report
PRODUCT_TRANSFER_DATE DATE

Document date
TRACING_FLAG VARCHAR2 (1)
SHIP_FROM_CUST_ACCOUNT_ID NUMBER

cust account of shipper
SHIP_FROM_SITE_ID NUMBER

Ship From Site Use ID
SHIP_FROM_PARTY_NAME VARCHAR2 (360)
account name of the shiper
SHIP_FROM_LOCATION VARCHAR2 (40)
SHIP_FROM_ADDRESS VARCHAR2 (240)
Address of Shipper
SHIP_FROM_CITY VARCHAR2 (60)
City of Shipper
SHIP_FROM_STATE VARCHAR2 (60)
State of Shipper
SHIP_FROM_POSTAL_CODE VARCHAR2 (60)
Postal Code of Shipper
SHIP_FROM_COUNTRY VARCHAR2 (60)
Country of Shipper
SHIP_FROM_CONTACT_PARTY_ID NUMBER

Ship Form Contact Communication Type
SHIP_FROM_CONTACT_NAME VARCHAR2 (360)
Contact Name of Shipper
SHIP_FROM_EMAIL VARCHAR2 (2000)
Ship From Contact Number
SHIP_FROM_FAX VARCHAR2 (60)
SHIP_FROM_PHONE VARCHAR2 (60)
SOLD_FROM_CUST_ACCOUNT_ID NUMBER

cust account of seller
SOLD_FROM_SITE_ID NUMBER

Site Use ID of Seller
SOLD_FROM_PARTY_NAME VARCHAR2 (360)
account name of the seller
SOLD_FROM_LOCATION VARCHAR2 (40)
SOLD_FROM_ADDRESS VARCHAR2 (240)
Address of Seller
SOLD_FROM_CITY VARCHAR2 (60)
City of Seller
SOLD_FROM_STATE VARCHAR2 (60)
State of Seller
SOLD_FROM_POSTAL_CODE VARCHAR2 (60)
Sold From Postal Code
SOLD_FROM_COUNTRY VARCHAR2 (60)
Country of Seller
SOLD_FROM_CONTACT_PARTY_ID NUMBER

Type of contact to Seller
SOLD_FROM_CONTACT_NAME VARCHAR2 (360)
Contact Name for Seller
SOLD_FROM_EMAIL VARCHAR2 (2000)
Contact Number of Seller
SOLD_FROM_PHONE VARCHAR2 (60)
SOLD_FROM_FAX VARCHAR2 (60)
BILL_TO_CUST_ACCOUNT_ID NUMBER

cust account of the bill to customer
BILL_TO_SITE_USE_ID NUMBER

bill to site id
BILL_TO_PARTY_NAME VARCHAR2 (360)
account name of bill to customer
BILL_TO_DUNS_NUMBER VARCHAR2 (30)
BILL_TO_LOCATION VARCHAR2 (40)
bill to location
BILL_TO_ADDRESS VARCHAR2 (240)
Bill To Address
BILL_TO_CITY VARCHAR2 (60)
Bill To City
BILL_TO_STATE VARCHAR2 (60)
Bill To State
BILL_TO_POSTAL_CODE VARCHAR2 (60)
Bill To Postal Code
BILL_TO_COUNTRY VARCHAR2 (60)
Bill To Country
BILL_TO_CONTACT_PARTY_ID NUMBER

Bill To Contact Communication Type
BILL_TO_CONTACT_NAME VARCHAR2 (360)
Bill To Contact Name
BILL_TO_EMAIL VARCHAR2 (2000)
Bill To Contact Number
BILL_TO_PHONE VARCHAR2 (60)
BILL_TO_FAX VARCHAR2 (60)
SHIP_TO_CUST_ACCOUNT_ID NUMBER

Cust account of the ship to customer
SHIP_TO_SITE_USE_ID NUMBER

ship to site use id
SHIP_TO_PARTY_NAME VARCHAR2 (360)
account name for ship to
SHIP_TO_DUNS_NUMBER VARCHAR2 (30)
SHIP_TO_LOCATION VARCHAR2 (40)
ship to location
SHIP_TO_ADDRESS VARCHAR2 (240)
Ship To Address
SHIP_TO_CITY VARCHAR2 (60)
Ship To City
SHIP_TO_COUNTRY VARCHAR2 (60)
Ship To Country
SHIP_TO_POSTAL_CODE VARCHAR2 (60)
Ship To Postal Code
SHIP_TO_STATE VARCHAR2 (60)
Ship To State
SHIP_TO_CONTACT_PARTY_ID NUMBER

Ship To Contact Communication Type
SHIP_TO_CONTACT_NAME VARCHAR2 (360)
Ship To Contact Name
SHIP_TO_EMAIL VARCHAR2 (2000)
Ship To Contact Number
SHIP_TO_PHONE VARCHAR2 (60)
SHIP_TO_FAX VARCHAR2 (60)
END_CUST_PARTY_ID NUMBER

End User Party ID
END_CUST_SITE_USE_ID NUMBER

End User Site Use ID
END_CUST_SITE_USE_CODE VARCHAR2 (30)
END_CUST_PARTY_SITE_ID NUMBER

End User Party Site ID
END_CUST_PARTY_NAME VARCHAR2 (360)
End User Party Name
END_CUST_LOCATION VARCHAR2 (40)
End User Location
END_CUST_ADDRESS VARCHAR2 (240)
End User Address
END_CUST_CITY VARCHAR2 (60)
End User City
END_CUST_STATE VARCHAR2 (60)
End User State
END_CUST_POSTAL_CODE VARCHAR2 (60)
End User Postal Code
END_CUST_COUNTRY VARCHAR2 (60)
End User Country
END_CUST_CONTACT_PARTY_ID NUMBER

End User Contact party id
END_CUST_CONTACT_NAME VARCHAR2 (360)
End User Contact Name
END_CUST_EMAIL VARCHAR2 (2000)
End User Contact Number
END_CUST_PHONE VARCHAR2 (60)
END_CUST_FAX VARCHAR2 (60)
DIRECT_CUSTOMER_FLAG VARCHAR2 (1)
direct customer flag
ORDER_TYPE_ID NUMBER

ORDER_TYPE VARCHAR2 (30)
ORDER_CATEGORY VARCHAR2 (30)
AGREEMENT_TYPE VARCHAR2 (30)
AGREEMENT_ID NUMBER

Agreement ID
AGREEMENT_NAME VARCHAR2 (240)
Agreement Number
AGREEMENT_PRICE NUMBER

Contract Price
AGREEMENT_UOM_CODE VARCHAR2 (3)
Base Unit of Measurement for price
CORRECTED_AGREEMENT_ID NUMBER

CORRECTED_AGREEMENT_NAME VARCHAR2 (240)
PRICE_LIST_ID NUMBER

price list id
PRICE_LIST_NAME VARCHAR2 (240)
name of the price list
ORIG_SYSTEM_REFERENCE VARCHAR2 (30)
reference in the original system
ORIG_SYSTEM_LINE_REFERENCE VARCHAR2 (30)
line reference in the original system
ORIG_SYSTEM_CURRENCY_CODE VARCHAR2 (15)
currency code in original system
ORIG_SYSTEM_SELLING_PRICE NUMBER

selling price in original system
ORIG_SYSTEM_QUANTITY NUMBER

quantity in orig_system_uom
ORIG_SYSTEM_UOM VARCHAR2 (240)
uom in the original system
ORIG_SYSTEM_PURCHASE_UOM VARCHAR2 (240)
ORIG_SYSTEM_PURCHASE_CURR VARCHAR2 (15)
ORIG_SYSTEM_PURCHASE_PRICE NUMBER

ORIG_SYSTEM_PURCHASE_QUANTITY NUMBER

ORIG_SYSTEM_AGREEMENT_UOM VARCHAR2 (240)
ORIG_SYSTEM_AGREEMENT_NAME VARCHAR2 (240)
ORIG_SYSTEM_AGREEMENT_TYPE VARCHAR2 (30)
ORIG_SYSTEM_AGREEMENT_STATUS VARCHAR2 (30)
ORIG_SYSTEM_AGREEMENT_CURR VARCHAR2 (15)
ORIG_SYSTEM_AGREEMENT_PRICE NUMBER

ORIG_SYSTEM_AGREEMENT_QUANTITY NUMBER

Unit of Measure for selling price in original system
ORIG_SYSTEM_ITEM_NUMBER VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (15)
currency code
EXCHANGE_RATE NUMBER

Exchange Rate for currency
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Market on which exchange rate is based on
EXCHANGE_RATE_DATE DATE

PO_NUMBER VARCHAR2 (50)
Purchase Order Number
PO_RELEASE_NUMBER VARCHAR2 (240)
Version Nmber of Purchase Order
PO_TYPE VARCHAR2 (30)
Type of Purchase Order
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
DATE_INVOICED DATE

Invoice Date
ORDER_NUMBER VARCHAR2 (30)
Order number
DATE_ORDERED DATE

DATE_SHIPPED DATE

CLAIMED_AMOUNT NUMBER

Claimed Amount
TOTAL_CLAIMED_AMOUNT NUMBER

Line Amount
PURCHASE_PRICE NUMBER

Net Adjusted Amount
PURCHASE_UOM_CODE VARCHAR2 (3)
SELLING_PRICE NUMBER

selling price
UOM_CODE VARCHAR2 (3)
unit of measure
QUANTITY NUMBER

quanity in uom
CREDIT_CODE VARCHAR2 (30)
Credit/Debit Flag
CREDIT_ADVICE_DATE DATE

Credit Advice Date
UPC_CODE VARCHAR2 (30)
UPC Code
INVENTORY_ITEM_ID NUMBER

inventory item id
ITEM_NUMBER VARCHAR2 (240)
Vendor Part Number
ITEM_DESCRIPTION VARCHAR2 (30)
Item Description
INVENTORY_ITEM_SEGMENT1 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT2 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT3 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT4 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT5 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT6 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT7 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT8 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT9 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT10 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT11 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT12 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT13 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT14 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT15 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT16 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT17 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT18 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT19 VARCHAR2 (40)
inventory item segment
INVENTORY_ITEM_SEGMENT20 VARCHAR2 (40)
inventory item segment
PRODUCT_CATEGORY_ID NUMBER

id of the product category
CATEGORY_NAME VARCHAR2 (240)
Name of the category
DUPLICATED_LINE_ID NUMBER

Sold Date
DUPLICATED_ADJUSTMENT_ID NUMBER

Returned Date
RESPONSE_TYPE VARCHAR2 (30)
Type indicating Yes/No response or others for 849 EDI
RESPONSE_CODE VARCHAR2 (30)
Response Code for 849 Outbound Transaction Set
REJECT_REASON_CODE VARCHAR2 (30)
Reason for rejecting the claim
FOLLOWUP_ACTION_CODE VARCHAR2 (30)
Followup Actions allowed for resubmission of claim
NET_ADJUSTED_AMOUNT NUMBER

HEADER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column for header only
HEADER_ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment for header
HEADER_ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment for header
LINE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column for line only
LINE_ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment for line
LINE_ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment for line
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
,      LAST_UPDATE_LOGIN
,      BATCH_TYPE
,      BATCH_NUMBER
,      BATCH_COUNT
,      YEAR
,      MONTH
,      REPORT_DATE
,      REPORT_START_DATE
,      REPORT_END_DATE
,      REFERENCE_TYPE
,      REFERENCE_NUMBER
,      COMMENTS
,      PARTNER_CLAIM_NUMBER
,      TRANSACTION_PURPOSE_CODE
,      TRANSACTION_TYPE_CODE
,      PARTNER_TYPE
,      PARTNER_PARTY_ID
,      PARTNER_CUST_ACCOUNT_ID
,      PARTNER_SITE_ID
,      PARTNER_CONTACT_PARTY_ID
,      PARTNER_CONTACT_NAME
,      PARTNER_EMAIL
,      PARTNER_PHONE
,      PARTNER_FAX
,      BATCH_CURRENCY_CODE
,      BATCH_CLAIMED_AMOUNT
,      BATCH_CREDIT_CODE
,      BATCH_CREDIT_ADVICE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RESALE_LINE_INT_ID
,      RESALE_TRANSFER_TYPE
,      PRODUCT_TRANSFER_MOVEMENT_TYPE
,      PRODUCT_TRANSFER_DATE
,      TRACING_FLAG
,      SHIP_FROM_CUST_ACCOUNT_ID
,      SHIP_FROM_SITE_ID
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_LOCATION
,      SHIP_FROM_ADDRESS
,      SHIP_FROM_CITY
,      SHIP_FROM_STATE
,      SHIP_FROM_POSTAL_CODE
,      SHIP_FROM_COUNTRY
,      SHIP_FROM_CONTACT_PARTY_ID
,      SHIP_FROM_CONTACT_NAME
,      SHIP_FROM_EMAIL
,      SHIP_FROM_FAX
,      SHIP_FROM_PHONE
,      SOLD_FROM_CUST_ACCOUNT_ID
,      SOLD_FROM_SITE_ID
,      SOLD_FROM_PARTY_NAME
,      SOLD_FROM_LOCATION
,      SOLD_FROM_ADDRESS
,      SOLD_FROM_CITY
,      SOLD_FROM_STATE
,      SOLD_FROM_POSTAL_CODE
,      SOLD_FROM_COUNTRY
,      SOLD_FROM_CONTACT_PARTY_ID
,      SOLD_FROM_CONTACT_NAME
,      SOLD_FROM_EMAIL
,      SOLD_FROM_PHONE
,      SOLD_FROM_FAX
,      BILL_TO_CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_PARTY_NAME
,      BILL_TO_DUNS_NUMBER
,      BILL_TO_LOCATION
,      BILL_TO_ADDRESS
,      BILL_TO_CITY
,      BILL_TO_STATE
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTRY
,      BILL_TO_CONTACT_PARTY_ID
,      BILL_TO_CONTACT_NAME
,      BILL_TO_EMAIL
,      BILL_TO_PHONE
,      BILL_TO_FAX
,      SHIP_TO_CUST_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_DUNS_NUMBER
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS
,      SHIP_TO_CITY
,      SHIP_TO_COUNTRY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_STATE
,      SHIP_TO_CONTACT_PARTY_ID
,      SHIP_TO_CONTACT_NAME
,      SHIP_TO_EMAIL
,      SHIP_TO_PHONE
,      SHIP_TO_FAX
,      END_CUST_PARTY_ID
,      END_CUST_SITE_USE_ID
,      END_CUST_SITE_USE_CODE
,      END_CUST_PARTY_SITE_ID
,      END_CUST_PARTY_NAME
,      END_CUST_LOCATION
,      END_CUST_ADDRESS
,      END_CUST_CITY
,      END_CUST_STATE
,      END_CUST_POSTAL_CODE
,      END_CUST_COUNTRY
,      END_CUST_CONTACT_PARTY_ID
,      END_CUST_CONTACT_NAME
,      END_CUST_EMAIL
,      END_CUST_PHONE
,      END_CUST_FAX
,      DIRECT_CUSTOMER_FLAG
,      ORDER_TYPE_ID
,      ORDER_TYPE
,      ORDER_CATEGORY
,      AGREEMENT_TYPE
,      AGREEMENT_ID
,      AGREEMENT_NAME
,      AGREEMENT_PRICE
,      AGREEMENT_UOM_CODE
,      CORRECTED_AGREEMENT_ID
,      CORRECTED_AGREEMENT_NAME
,      PRICE_LIST_ID
,      PRICE_LIST_NAME
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_LINE_REFERENCE
,      ORIG_SYSTEM_CURRENCY_CODE
,      ORIG_SYSTEM_SELLING_PRICE
,      ORIG_SYSTEM_QUANTITY
,      ORIG_SYSTEM_UOM
,      ORIG_SYSTEM_PURCHASE_UOM
,      ORIG_SYSTEM_PURCHASE_CURR
,      ORIG_SYSTEM_PURCHASE_PRICE
,      ORIG_SYSTEM_PURCHASE_QUANTITY
,      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
,      ORIG_SYSTEM_ITEM_NUMBER
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      PO_NUMBER
,      PO_RELEASE_NUMBER
,      PO_TYPE
,      INVOICE_NUMBER
,      DATE_INVOICED
,      ORDER_NUMBER
,      DATE_ORDERED
,      DATE_SHIPPED
,      CLAIMED_AMOUNT
,      TOTAL_CLAIMED_AMOUNT
,      PURCHASE_PRICE
,      PURCHASE_UOM_CODE
,      SELLING_PRICE
,      UOM_CODE
,      QUANTITY
,      CREDIT_CODE
,      CREDIT_ADVICE_DATE
,      UPC_CODE
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      INVENTORY_ITEM_SEGMENT1
,      INVENTORY_ITEM_SEGMENT2
,      INVENTORY_ITEM_SEGMENT3
,      INVENTORY_ITEM_SEGMENT4
,      INVENTORY_ITEM_SEGMENT5
,      INVENTORY_ITEM_SEGMENT6
,      INVENTORY_ITEM_SEGMENT7
,      INVENTORY_ITEM_SEGMENT8
,      INVENTORY_ITEM_SEGMENT9
,      INVENTORY_ITEM_SEGMENT10
,      INVENTORY_ITEM_SEGMENT11
,      INVENTORY_ITEM_SEGMENT12
,      INVENTORY_ITEM_SEGMENT13
,      INVENTORY_ITEM_SEGMENT14
,      INVENTORY_ITEM_SEGMENT15
,      INVENTORY_ITEM_SEGMENT16
,      INVENTORY_ITEM_SEGMENT17
,      INVENTORY_ITEM_SEGMENT18
,      INVENTORY_ITEM_SEGMENT19
,      INVENTORY_ITEM_SEGMENT20
,      PRODUCT_CATEGORY_ID
,      CATEGORY_NAME
,      DUPLICATED_LINE_ID
,      DUPLICATED_ADJUSTMENT_ID
,      RESPONSE_TYPE
,      RESPONSE_CODE
,      REJECT_REASON_CODE
,      FOLLOWUP_ACTION_CODE
,      NET_ADJUSTED_AMOUNT
,      HEADER_ATTRIBUTE_CATEGORY
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_ATTRIBUTE11
,      HEADER_ATTRIBUTE12
,      HEADER_ATTRIBUTE13
,      HEADER_ATTRIBUTE14
,      HEADER_ATTRIBUTE15
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
FROM APPS.OZF_RESALE_WEBADI_DOWNLOAD_V;

Dependencies

[top of page]

APPS.OZF_RESALE_WEBADI_DOWNLOAD_V references the following:

SchemaAPPS
SynonymOZF_RESALE_BATCHES_ALL
SynonymOZF_RESALE_LINES_INT_ALL

APPS.OZF_RESALE_WEBADI_DOWNLOAD_V is not referenced by any database object