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

VIEW: APPS.WIP_BIS_PROD_ASSY_YIELD_V

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

View Type

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


Shows the total quantity and scrapped quantity for a particular
organization at a particular transaction date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER

Set of Books Identifier
LEDGER_NAME VARCHAR2 (30)
Set of Books Name
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name
OPERATING_UNIT_ID NUMBER

Operating Unit Identifier
OPERATING_UNIT_NAME VARCHAR2 (240)
Operating Unit Name
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
WIP_ENTITY_ID NUMBER

WIP Entity Identifier
CATEGORY_ID NUMBER

Category Identifier
CATEGORY_NAME VARCHAR2 (163)
Category Name
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
INVENTORY_ITEM_NAME VARCHAR2 (40)
Inventory Item Name
LOCATION_ID NUMBER

Location Identifier
AREA_CODE VARCHAR2 (30)
Area Code
AREA_NAME VARCHAR2 (80)
Area Name
COUNTRY_CODE VARCHAR2 (60)
Country Code
COUNTRY_NAME VARCHAR2 (80)
Country Name
REGION_CODE VARCHAR2 (30)
Region Code
REGION_NAME VARCHAR2 (80)
Region Name
TRANSACTION_DATE DATE

Transaction Date
PERIOD_SET_NAME VARCHAR2 (15)
Period Set Name
PERIOD_YEAR VARCHAR2 (15)
Period Year
PERIOD_QUARTER VARCHAR2 (15)
Period Quarter
PERIOD_MONTH VARCHAR2 (15)
Period Month
COMPLETED_QUANTITY NUMBER

Completed quantity
SCRAP_QUANTITY NUMBER

Scrapped Quantity
TOTAL_QUANTITY NUMBER

Total Quantity
Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      WIP_ENTITY_ID
,      CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      LOCATION_ID
,      AREA_CODE
,      AREA_NAME
,      COUNTRY_CODE
,      COUNTRY_NAME
,      REGION_CODE
,      REGION_NAME
,      TRANSACTION_DATE
,      PERIOD_SET_NAME
,      PERIOD_YEAR
,      PERIOD_QUARTER
,      PERIOD_MONTH
,      COMPLETED_QUANTITY
,      SCRAP_QUANTITY
,      TOTAL_QUANTITY
FROM APPS.WIP_BIS_PROD_ASSY_YIELD_V;

Dependencies

[top of page]

APPS.WIP_BIS_PROD_ASSY_YIELD_V references the following:

SchemaAPPS
SynonymWIP_BIS_PROD_ASSY_YIELD

APPS.WIP_BIS_PROD_ASSY_YIELD_V is not referenced by any database object