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_PERIOD_BALANCE

Object Details

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

Table that stores WIP inventory balance for each inventory accounting period.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization ID.
ORGANIZATION_NAME	VARCHAR2	(240)	Organization Name.
LEGAL_ENTITY	NUMBER		Legal Entity ID.
SCHEDULE_CLOSE_DATE	DATE		Accounting Period Scheduled Close Date.
CATEGORY_ID	NUMBER		Category ID.
CONCATENATED_SEGMENTS	VARCHAR2	(122)	Category Name.
PERIOD_SET_NAME	VARCHAR2	(15)	Period Set Name.
PERIOD_NAME	VARCHAR2	(15)	Period Name.
BALANCE	NUMBER		WIP Inventory Balance.

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_NAME
,      LEGAL_ENTITY
,      SCHEDULE_CLOSE_DATE
,      CATEGORY_ID
,      CONCATENATED_SEGMENTS
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      BALANCE
FROM WIP.WIP_BIS_PERIOD_BALANCE;

Dependencies

[top of page]

WIP.WIP_BIS_PERIOD_BALANCE does not reference any database object

WIP.WIP_BIS_PERIOD_BALANCE is referenced by following:

WIP: WIP_BIS_PERIOD_BALANCE#