eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ENI.EDW_ITEM_ITEMORG_LSTG

Object Details

Object Name:	EDW_ITEM_ITEMORG_LSTG
Object Type:	TABLE
Owner:	ENI
Subobject Name:
Status:	VALID

This is the interface table for Organization Item level table. Data from multiple transactional systems is staged here for verfication and cleansing, before loading it into the dimension level table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_ITEM_ITEMORG_LSTG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ITEM_ORG_PK
EDW_ITEM_ITEMORG_LSTG_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COLLECTION_STATUS

Columns

Name	Datatype	Length	Comments
CATSET_CATEGORY_FK_KEY	NUMBER		System generated foreign key to the first level of the organization item category
HAZARD_CLASS_ID	NUMBER		Hazard class ID
ITEM_NUMBER_FK_KEY	NUMBER		System generated foreign key to the Item Category level
MARKET_PRICE	NUMBER		Market price
PRICE_TOL_PERCENT	NUMBER		Price tolerance percentage
PROD_FAMILY_FK_KEY	NUMBER		System generated foreign key to the Product Family Category level
REQUEST_ID	NUMBER		Standard Who column
SHELF_LIFE_DAYS	NUMBER		Shelf life days
UNIT_LIST_PRICE	NUMBER		Unit list price
UN_NUMBER_ID	NUMBER		Unit number ID
APPROVED_SUPPLIER	VARCHAR2	(20)	Approved supplier
BUYER_FK	VARCHAR2	(1000)	Foreign key to the Buyer level
COLLECTION_STATUS	VARCHAR2	(30)	Collection status code for the record
CATSET_CATEGORY_FK	VARCHAR2	(240)	Foreign key to the category set level
DESCRIPTION	VARCHAR2	(240)	Item Description
ERROR_CODE	VARCHAR2	(2000)	Error code
EXPRS_DELIVERY	VARCHAR2	(20)	Express delivery
INSP_REQUIRED	VARCHAR2	(40)	Inspection required
INSTANCE	VARCHAR2	(40)	Instance from which the record was collected
INTERNAL_ORD_FLAG	VARCHAR2	(20)	Flag indicating internally orderable item
INV_PLANNING_CODE	VARCHAR2	(40)	INV planning code
ITEM_NUMBER	VARCHAR2	(240)	Item number
ITEM_NUMBER_FK	VARCHAR2	(1000)	Foreign key to the Item level
ITEM_ORG_DP	VARCHAR2	(240)	Not currently used
ITEM_ORG_PK	VARCHAR2	(1000)	Unique identifier
LOCATOR_CONTROL	VARCHAR2	(80)	Stock locator control code
LOT_CONTROL	VARCHAR2	(80)	Lot locator control code
MAKE_OR_BUY_FLAG	VARCHAR2	(40)	Make or Buy flag
MRP_PLN_METHOD	VARCHAR2	(80)	MRP planning method
NAME	VARCHAR2	(320)	Item name
ONE_TIME_FLAG	VARCHAR2	(10)	One time flag
OPERATION_CODE	VARCHAR2	(30)	Operation code
OUTSIDE_OP_FLAG	VARCHAR2	(20)	Flag indicating item may appear on outside operation purchase order
PLANNER_FK	VARCHAR2	(1000)	System generated foreign key to the Planner level
PROD_FAMILY_FK	VARCHAR2	(320)	System generated foreign key to the Product Family Category level
PURCHASABLE_FLAG	VARCHAR2	(20)	Flag indicating whether item can be purchased
RECEIPT_REQUIRED	VARCHAR2	(20)	Flag indicating supplier receipt is required before payment
REVISION_CONTROL	VARCHAR2	(80)	Revision quantity control code
RFQ_REQUIRED_FLAG	VARCHAR2	(20)	RFQ required flag
ROW_ID	ROWID	(10)	Row ID
SERIAL_CONTROL	VARCHAR2	(80)	Serial number control code
SHELF_LIFE_CODE	VARCHAR2	(80)	Shelf life code
STOCKABLE_FLAG	VARCHAR2	(20)	Flag indicating if item is stockable
SUBSTITUTE_RCPT	VARCHAR2	(20)	Substitute receipt
TAXABLE_FLAG	VARCHAR2	(20)	Flag indicating if item is taxable
TAX_CODE	VARCHAR2	(80)	Tax code
UNORDERED_RCPT	VARCHAR2	(20)	Unordered receipt
SEGMENT1	VARCHAR2	(40)	Segment 1 of the item key flexfield
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute
CREATION_DATE	DATE		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
EFFECTIVITY_CONTROL	VARCHAR2	(80)	Falg indicating Model unit effectivity
INVENTORY_ITEM_ID	NUMBER		Inventory Item Surrogate Key
ORGANIZATION_ID	NUMBER		Organization Surrogate Key
CATEGORY_ID	NUMBER		Category Surrogate Key
CATEGORY_SET_ID	NUMBER		Category Set Surrogate Key
ITEM_TYPE	VARCHAR2	(30)	Item Type

Query Text

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


SELECT CATSET_CATEGORY_FK_KEY
,      HAZARD_CLASS_ID
,      ITEM_NUMBER_FK_KEY
,      MARKET_PRICE
,      PRICE_TOL_PERCENT
,      PROD_FAMILY_FK_KEY
,      REQUEST_ID
,      SHELF_LIFE_DAYS
,      UNIT_LIST_PRICE
,      UN_NUMBER_ID
,      APPROVED_SUPPLIER
,      BUYER_FK
,      COLLECTION_STATUS
,      CATSET_CATEGORY_FK
,      DESCRIPTION
,      ERROR_CODE
,      EXPRS_DELIVERY
,      INSP_REQUIRED
,      INSTANCE
,      INTERNAL_ORD_FLAG
,      INV_PLANNING_CODE
,      ITEM_NUMBER
,      ITEM_NUMBER_FK
,      ITEM_ORG_DP
,      ITEM_ORG_PK
,      LOCATOR_CONTROL
,      LOT_CONTROL
,      MAKE_OR_BUY_FLAG
,      MRP_PLN_METHOD
,      NAME
,      ONE_TIME_FLAG
,      OPERATION_CODE
,      OUTSIDE_OP_FLAG
,      PLANNER_FK
,      PROD_FAMILY_FK
,      PURCHASABLE_FLAG
,      RECEIPT_REQUIRED
,      REVISION_CONTROL
,      RFQ_REQUIRED_FLAG
,      ROW_ID
,      SERIAL_CONTROL
,      SHELF_LIFE_CODE
,      STOCKABLE_FLAG
,      SUBSTITUTE_RCPT
,      TAXABLE_FLAG
,      TAX_CODE
,      UNORDERED_RCPT
,      SEGMENT1
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      EFFECTIVITY_CONTROL
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      ITEM_TYPE
FROM ENI.EDW_ITEM_ITEMORG_LSTG;

Dependencies

[top of page]

ENI.EDW_ITEM_ITEMORG_LSTG does not reference any database object

ENI.EDW_ITEM_ITEMORG_LSTG is referenced by following:

APPS: EDW_ITEM_ITEMORG_LSTG