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

VIEW: APPS.WIP_BIS_PERIOD_BALANCE_V

Object Details
Object Name: WIP_BIS_PERIOD_BALANCE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_BIS_PERIOD_BALANCE_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


Shows the value for Work In Process for both discrete jobs
and repetitive schedules in each product category for a given
inventory accounting period time bucket (flow schedules are
not included)


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
LEGAL_ENTITY NUMBER

Legal Entity
SCHEDULE_CLOSE_DATE DATE

Schedule Close Date
CATEGORY_ID NUMBER

Category Identifier
CONCATENATED_SEGMENTS VARCHAR2 (122)
Concatenated Segments for Category
PERIOD_SET_NAME VARCHAR2 (15)
Period Set Name
PERIOD_NAME VARCHAR2 (15)
Period Name
BALANCE NUMBER

Period 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 APPS.WIP_BIS_PERIOD_BALANCE_V;

Dependencies

[top of page]

APPS.WIP_BIS_PERIOD_BALANCE_V references the following:

SchemaAPPS
SynonymWIP_BIS_PERIOD_BALANCE

APPS.WIP_BIS_PERIOD_BALANCE_V is not referenced by any database object