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: WIP.WIP_BIS_PERF_TO_PLAN

Object Details

Object Name:	WIP_BIS_PERF_TO_PLAN
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_BIS_PERF_TO_PLAN
Subobject Name:
Status:	VALID

WIP_BIS_PERF_TO_PLAN contains information about the scheduled and actual production of all assemblies in all organizations for every day in a given date range. The Capture Production Performance concurrent program populates information into this table for a given date range. The WIP Performance to MPS report is based on this table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_BIS_PERF_TO_PLAN_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVENTORY_ITEM_ID ORGANIZATION_ID
WIP_BIS_PERF_TO_PLAN_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SCHEDULE_DATE ORGANIZATION_ID

Columns

Name	Datatype	Mandatory	Comments
ORGANIZATION_ID	NUMBER	Yes	Organization Identifier
INVENTORY_ITEM_ID	NUMBER	Yes	Inventory item Identifier for the assembly the job or schedule creates
SCHEDULE_DATE	DATE	Yes	Production schedule date
SCHEDULE_QUANTITY	NUMBER		Quantity scheduled for completion
ACTUAL_QUANTITY	NUMBER		Quantity completed
ITEM_COST	NUMBER		Cost of making an Item
EXISTING_FLAG	NUMBER	Yes	Column used to differentiate between the existing data and newly generated data
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER		Enhanced Who column
PROGRAM_ID	NUMBER		Enhanced Who column
PROGRAM_UPDATE_DATE	DATE		Enhanced Who column

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SCHEDULE_DATE
,      SCHEDULE_QUANTITY
,      ACTUAL_QUANTITY
,      ITEM_COST
,      EXISTING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM WIP.WIP_BIS_PERF_TO_PLAN;

Dependencies

[top of page]

WIP.WIP_BIS_PERF_TO_PLAN does not reference any database object

WIP.WIP_BIS_PERF_TO_PLAN is referenced by following:

APPS: WIP_BIS_PERF_TO_PLAN