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: APPS.OPI_CURR_PROD_DEL_001_MV

Object Details

Object Name:	OPI_CURR_PROD_DEL_001_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OPI_CURR_PROD_DEL_001_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Inventory Organization Identifier.
SOURCE	NUMBER		Yes	Data source. 1 = OPI,2 = OPM.
ASSEMBLY_ITEM_ID	NUMBER			Top level item identifier
UOM_CODE	VARCHAR2	(3)		Primary UOM Code.
ITEM_ORG_ID	VARCHAR2	(81)		Inventory Item Organization Identifier.
INV_CATEGORY_ID	NUMBER			Inventory Category Identifier.
ITEM_CAT_FLAG	NUMBER			Item Category Flag.
LATE_JOBS_CNT	NUMBER			Count column.
LATE_JOBS_QTY	NUMBER			Quantity of items for the jobs that passed scheduled completion date
LATE_JOBS_VAL_B	NUMBER			Value of items for the jobs that passed scheduled completion date
LATE_JOBS_VAL_G	NUMBER			Item value for this job which has passed scheduled completetion date in primary global currency
LATE_JOBS_VAL_SG	NUMBER			Item value for this job which has passed scheduled completetion date in secondary global currency
OPEN_JOBS_CNT	NUMBER			Count column.
OPEN_JOBS_QTY	NUMBER			Item quantity for the job which is still open
OPEN_JOBS_VAL_B	NUMBER			Item value in functional currency for the job which is still open
OPEN_JOBS_VAL_G	NUMBER			Item value in global currency for the job which is still open
OPEN_JOBS_VAL_SG	NUMBER			Item value in secondary global currency for the job which is still open

Query Text

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


SELECT ORGANIZATION_ID
,      SOURCE
,      ASSEMBLY_ITEM_ID
,      UOM_CODE
,      ITEM_ORG_ID
,      INV_CATEGORY_ID
,      ITEM_CAT_FLAG
,      LATE_JOBS_CNT
,      LATE_JOBS_QTY
,      LATE_JOBS_VAL_B
,      LATE_JOBS_VAL_G
,      LATE_JOBS_VAL_SG
,      OPEN_JOBS_CNT
,      OPEN_JOBS_QTY
,      OPEN_JOBS_VAL_B
,      OPEN_JOBS_VAL_G
,      OPEN_JOBS_VAL_SG
FROM APPS.OPI_CURR_PROD_DEL_001_MV;

Dependencies

[top of page]

APPS.OPI_CURR_PROD_DEL_001_MV does not reference any database object

APPS.OPI_CURR_PROD_DEL_001_MV is referenced by following:

APPS: OPI_CURR_PROD_DEL_001_MV