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


TABLE: OZF.OZF_RESALE_LINES_ALL

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


OZF_CHARGEBACK_LINES_ALL STORES LINE LEVEL 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_LINES_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESALE_LINE_ID
OZF_RESALE_LINES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATE_ORDERED
ColumnINVENTORY_ITEM_ID
ColumnORDER_NUMBER
ColumnQUANTITY
ColumnSHIP_FROM_CUST_ACCOUNT_ID
ColumnSOLD_FROM_CUST_ACCOUNT_ID
ColumnUOM_CODE
OZF_RESALE_LINES_ALL_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_LOCATION
OZF_RESALE_LINES_ALL_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_CUST_LOCATION
OZF_RESALE_LINES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESALE_HEADER_ID
OZF_RESALE_LINES_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_ITEM_NUMBER
OZF_RESALE_LINES_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_UOM
OZF_RESALE_LINES_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_PURCHASE_UOM
OZF_RESALE_LINES_ALL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_TO_PARTY_NAME
OZF_RESALE_LINES_ALL_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_PARTY_NAME
OZF_RESALE_LINES_ALL_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_CUST_PARTY_NAME
OZF_RESALE_LINES_ALL_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_TO_LOCATION
Columns
Name Datatype Length Mandatory Comments
RESALE_LINE_ID NUMBER
Yes Unique Identifier
RESALE_HEADER_ID NUMBER
Yes Resale Header Identifier
RESALE_TRANSFER_TYPE VARCHAR2 (30)
Type of Product Transfer
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
STATUS_CODE VARCHAR2 (10)
Line Status
PRODUCT_TRANSFER_MOVEMENT_TYPE VARCHAR2 (30)
Type of Product Transfer Movement
PRODUCT_TRANSFER_DATE DATE

Date of Product Transfer
END_CUST_PARTY_ID NUMBER

End CustomerParty Identifier
END_CUST_SITE_USE_ID NUMBER

End Customer Site Use Identifier
END_CUST_SITE_USE_CODE VARCHAR2 (30)
End Customer Site Use Type
END_CUST_PARTY_SITE_ID NUMBER

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

End Customer Contact Party Identifier
END_CUST_CONTACT_NAME VARCHAR2 (360)
End Customer Contact Name
END_CUST_PHONE VARCHAR2 (60)
End Customer Phone Number
END_CUST_FAX VARCHAR2 (60)
End Customer Fax Number
END_CUST_EMAIL VARCHAR2 (2000)
End Customer Email Address
BILL_TO_CUST_ACCOUNT_ID NUMBER

Buying Customer Account Identifier
BILL_TO_SITE_USE_ID NUMBER

Buying Customer Site Identifier
BILL_TO_PARTY_NAME VARCHAR2 (360)
Buying Customer Name
BILL_TO_PARTY_ID NUMBER

Buying Customer Identifier
BILL_TO_PARTY_SITE_ID NUMBER

Buying Customer Site Identifier
BILL_TO_DUNS_NUMBER VARCHAR2 (30)
Buying Customer DUNS Number
BILL_TO_LOCATION VARCHAR2 (40)
Buying Customer Location Code
BILL_TO_ADDRESS VARCHAR2 (240)
Buying Customer Address
BILL_TO_CITY VARCHAR2 (60)
Buying Customer City
BILL_TO_STATE VARCHAR2 (60)
Buying Customer State
BILL_TO_POSTAL_CODE VARCHAR2 (60)
Buying Cutomer Postal Code
BILL_TO_COUNTRY VARCHAR2 (60)
Buying Cutomer Country
BILL_TO_CONTACT_PARTY_ID NUMBER

Buying Cutomer Contact Party Identifier
BILL_TO_CONTACT_NAME VARCHAR2 (360)
Buying Customer Contact Name
BILL_TO_EMAIL VARCHAR2 (2000)
Buying Customer Email Address
BILL_TO_PHONE VARCHAR2 (60)
Buying Customer Phone Number
BILL_TO_FAX VARCHAR2 (60)
Buying Customer Fax Number
SHIP_TO_CUST_ACCOUNT_ID NUMBER

Receiving Customer Account Identifier
SHIP_TO_SITE_USE_ID NUMBER

Receiving Customer Site Use Identifier
SHIP_TO_PARTY_NAME VARCHAR2 (360)
Receiving Customer Name
SHIP_TO_PARTY_ID NUMBER

Receiving Customer Identifier
SHIP_TO_PARTY_SITE_ID NUMBER

Receiving Customer Site Identifier
SHIP_TO_DUNS_NUMBER VARCHAR2 (30)
Receiving Customer DUNS Number
SHIP_TO_LOCATION VARCHAR2 (40)
Receiving Customer Location Code
SHIP_TO_ADDRESS VARCHAR2 (240)
Receiving Customer Address
SHIP_TO_CITY VARCHAR2 (60)
Receiving Customer City
SHIP_TO_STATE VARCHAR2 (60)
Receiving Customer State
SHIP_TO_POSTAL_CODE VARCHAR2 (60)
Receiving Customer Postal Code
SHIP_TO_COUNTRY VARCHAR2 (60)
Receiving Customer Country
SHIP_TO_CONTACT_PARTY_ID NUMBER

Receiving Customer Contact Party Identifier
SHIP_TO_CONTACT_NAME VARCHAR2 (360)
Receiving Customer Contact Name
SHIP_TO_EMAIL VARCHAR2 (2000)
Receiving Customer Email Address
SHIP_TO_PHONE VARCHAR2 (60)
Receiving Customer Phone Number
SHIP_TO_FAX VARCHAR2 (60)
Receiving Customer Fax Number
SHIP_FROM_CUST_ACCOUNT_ID NUMBER

Shipping Customer Account Identifier
SHIP_FROM_SITE_ID NUMBER

Shipping Customer Site Identifier
SHIP_FROM_PARTY_NAME VARCHAR2 (360)
Shipping Customer Name
SHIP_FROM_LOCATION VARCHAR2 (40)
Shipping Customer Location Code
SHIP_FROM_ADDRESS VARCHAR2 (240)
Shipping Customer Address
SHIP_FROM_CITY VARCHAR2 (60)
Shipping Customer City
SHIP_FROM_STATE VARCHAR2 (60)
Shipping Customer State
SHIP_FROM_POSTAL_CODE VARCHAR2 (60)
Shipping Customer Postal Code
SHIP_FROM_COUNTRY VARCHAR2 (60)
Shipping Customer Country
SHIP_FROM_CONTACT_PARTY_ID NUMBER

Shipping Customer Contact Party Identifier
SHIP_FROM_CONTACT_NAME VARCHAR2 (360)
Shipping Customer Contact Name
SHIP_FROM_EMAIL VARCHAR2 (2000)
Shipping Customer Email Address
SHIP_FROM_PHONE VARCHAR2 (60)
Shipping Customer Phone Number
SHIP_FROM_FAX VARCHAR2 (60)
Shipping Customer Fax Number
SOLD_FROM_CUST_ACCOUNT_ID NUMBER

Selling Customer Account Identifier
SOLD_FROM_SITE_ID NUMBER

Selling Customer Site Identifier
SOLD_FROM_PARTY_NAME VARCHAR2 (360)
Selling Customer Name
SOLD_FROM_LOCATION VARCHAR2 (40)
Selling Customer Location Code
SOLD_FROM_ADDRESS VARCHAR2 (240)
Selling Customer Address
SOLD_FROM_CITY VARCHAR2 (60)
Selling Customer City
SOLD_FROM_STATE VARCHAR2 (60)
Selling Customer State
SOLD_FROM_POSTAL_CODE VARCHAR2 (60)
Selling Customer Postal Code
SOLD_FROM_COUNTRY VARCHAR2 (60)
Selling Customer Country
SOLD_FROM_CONTACT_PARTY_ID NUMBER

Selling Customer Contact Party Identidier
SOLD_FROM_CONTACT_NAME VARCHAR2 (360)
Selling Customer Contact Name
SOLD_FROM_EMAIL VARCHAR2 (2000)
Selling Customer Email Address
SOLD_FROM_PHONE VARCHAR2 (60)
Selling Customer Phone Number
SOLD_FROM_FAX VARCHAR2 (60)
Selling Customer Fax Number
PRICE_LIST_ID NUMBER

Price List Identifier
PRICE_LIST_NAME VARCHAR2 (240)
Price List Name
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
DATE_INVOICED DATE

Invoice Date
PO_NUMBER VARCHAR2 (50)
Purchase Order Number
PO_RELEASE_NUMBER VARCHAR2 (240)
Purchase Order Release Number
PO_TYPE VARCHAR2 (30)
Purchase Order Type
ORDER_NUMBER VARCHAR2 (50)
Order Nmber
DATE_ORDERED DATE

Date Ordered
DATE_SHIPPED DATE

Date Shipped
PURCHASE_UOM_CODE VARCHAR2 (3)
Unit of Measure for Purchase Price
QUANTITY NUMBER

Quantity
UOM_CODE VARCHAR2 (3)
Unit of Measure
CURRENCY_CODE VARCHAR2 (15)
Currency Code
EXCHANGE_RATE NUMBER

Rate of Exchange
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Rate Type of Exchange
EXCHANGE_RATE_DATE DATE

Date of Exchange
SELLING_PRICE NUMBER

Selling Price
ACCTD_SELLING_PRICE NUMBER

Adjusted Selling Price in Functional Currency
PURCHASE_PRICE NUMBER

Purchase Price
ACCTD_PURCHASE_PRICE NUMBER

Adjusted Purchase Price in Functional Currency
ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Reference in Originating System
ORIG_SYSTEM_LINE_REFERENCE VARCHAR2 (30)
Line Reference in the Originating System
ORIG_SYSTEM_CURRENCY_CODE VARCHAR2 (15)
Currency in Originating System
ORIG_SYSTEM_SELLING_PRICE NUMBER

Selling Price in Originating System
ORIG_SYSTEM_QUANTITY NUMBER

Quantity in Originating System Unit of Measure
ORIG_SYSTEM_UOM VARCHAR2 (240)
Unit of Measure in Originating System
ORIG_SYSTEM_PURCHASE_UOM VARCHAR2 (240)
Purchase Unit of Measure in Originating System
ORIG_SYSTEM_PURCHASE_CURR VARCHAR2 (15)
Purchase Currency in Originating System
ORIG_SYSTEM_PURCHASE_PRICE NUMBER

Purchase Price in Originating System
ORIG_SYSTEM_PURCHASE_QUANTITY NUMBER

Purchase Quantity in Originating System
ORIG_SYSTEM_ITEM_NUMBER VARCHAR2 (240)
Item Number in Originating System
TRACING_FLAG VARCHAR2 (1)
Indicator to check if line is a tracing line
PRODUCT_CATEGORY_ID NUMBER

Product Category Identifier
CATEGORY_NAME VARCHAR2 (240)
Name of the Category
INVENTORY_ITEM_SEGMENT1 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT2 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT3 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT4 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT5 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT6 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT7 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT8 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT9 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT10 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT11 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT12 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT13 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT14 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT15 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT16 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT17 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT18 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT19 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_SEGMENT20 VARCHAR2 (40)
Descriptive Flexfield for inventory item segment
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
UPC_CODE VARCHAR2 (30)
UPC Code
ITEM_NUMBER VARCHAR2 (50)
Item Number
DIRECT_CUSTOMER_FLAG VARCHAR2 (1)
Indicator for Direct or Indirect Customer
LINE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column for line
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
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
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 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
ORG_ID NUMBER

Organization identifier
SECURITY_GROUP_ID NUMBER

Used in hosted environments
DATA_SOURCE_CODE VARCHAR2 (30)
Data Source Code
INVOICE_LINE_NUMBER VARCHAR2 (30)
Invoice Line Number
ORDER_LINE_NUMBER VARCHAR2 (30)
Order Line Number
SUPPLIER_ITEM_COST NUMBER

Supplier Item Cost
SUPPLIER_ITEM_UOM VARCHAR2 (3)
Supplier Item Uom
Query Text

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


SELECT RESALE_LINE_ID
,      RESALE_HEADER_ID
,      RESALE_TRANSFER_TYPE
,      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
,      STATUS_CODE
,      PRODUCT_TRANSFER_MOVEMENT_TYPE
,      PRODUCT_TRANSFER_DATE
,      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_PHONE
,      END_CUST_FAX
,      END_CUST_EMAIL
,      BILL_TO_CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      BILL_TO_PARTY_NAME
,      BILL_TO_PARTY_ID
,      BILL_TO_PARTY_SITE_ID
,      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_PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_DUNS_NUMBER
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS
,      SHIP_TO_CITY
,      SHIP_TO_STATE
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY
,      SHIP_TO_CONTACT_PARTY_ID
,      SHIP_TO_CONTACT_NAME
,      SHIP_TO_EMAIL
,      SHIP_TO_PHONE
,      SHIP_TO_FAX
,      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_PHONE
,      SHIP_FROM_FAX
,      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
,      PRICE_LIST_ID
,      PRICE_LIST_NAME
,      INVOICE_NUMBER
,      DATE_INVOICED
,      PO_NUMBER
,      PO_RELEASE_NUMBER
,      PO_TYPE
,      ORDER_NUMBER
,      DATE_ORDERED
,      DATE_SHIPPED
,      PURCHASE_UOM_CODE
,      QUANTITY
,      UOM_CODE
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      SELLING_PRICE
,      ACCTD_SELLING_PRICE
,      PURCHASE_PRICE
,      ACCTD_PURCHASE_PRICE
,      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_ITEM_NUMBER
,      TRACING_FLAG
,      PRODUCT_CATEGORY_ID
,      CATEGORY_NAME
,      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
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      UPC_CODE
,      ITEM_NUMBER
,      DIRECT_CUSTOMER_FLAG
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE9
,      ATTRIBUTE8
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      DATA_SOURCE_CODE
,      INVOICE_LINE_NUMBER
,      ORDER_LINE_NUMBER
,      SUPPLIER_ITEM_COST
,      SUPPLIER_ITEM_UOM
FROM OZF.OZF_RESALE_LINES_ALL;

Dependencies

[top of page]

OZF.OZF_RESALE_LINES_ALL does not reference any database object

OZF.OZF_RESALE_LINES_ALL is referenced by following:

SchemaOZF
ViewOZF_RESALE_LINES_ALL#