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


VIEW: APPS.WIP_SUB_LOC_NET_AVAIL_VIEW

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization Identifier
INVENTORY_ITEM_ID NUMBER
Yes Item Identifier
ITEM_NUMBER VARCHAR2 (40)
Item number; Concatenated item segments
DESCRIPTION VARCHAR2 (240)
Item description
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory Code
LOCATOR_ID NUMBER

Location Identifier
BUYER_EMPLOYEE_NUM VARCHAR2 (30)
Employee's number
BUYER_NAME VARCHAR2 (240)
Employee's full name
PLANNER_CODE VARCHAR2 (10)
Planner code
PLANNING_MAKE_BUY_CODE VARCHAR2 (80)
Indicates whether item is planned as manufactured or purchased
NO_OF_OPEN_REQUIREMENTS NUMBER

Number of active jobs/schedules that require the component
REQUIRED_QUANTITY NUMBER

Total required quantity across active jobs/schedules for the component
QUANTITY_ISSUED NUMBER

Total quantity issued across active jobs/schedules for the component
QUANTITY_OPEN NUMBER

Total open requirements across active jobs/schedules for the component
NETTABLE_QUANTITY_ON_HAND NUMBER

Quantity on hand in nettable subinventories for the component
NONNETTABLE_QUANTITY_ON_HAND NUMBER

Quantity on hand in nonnettable subinventories for the component
TOTAL_QUANTITY_ON_HAND NUMBER

Total quantity on hand for the component
NET_AVAILABLE_QUANTITY NUMBER

Difference between nettable quantity on hand and quantity open for the component
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      DESCRIPTION
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      BUYER_EMPLOYEE_NUM
,      BUYER_NAME
,      PLANNER_CODE
,      PLANNING_MAKE_BUY_CODE
,      NO_OF_OPEN_REQUIREMENTS
,      REQUIRED_QUANTITY
,      QUANTITY_ISSUED
,      QUANTITY_OPEN
,      NETTABLE_QUANTITY_ON_HAND
,      NONNETTABLE_QUANTITY_ON_HAND
,      TOTAL_QUANTITY_ON_HAND
,      NET_AVAILABLE_QUANTITY
FROM APPS.WIP_SUB_LOC_NET_AVAIL_VIEW;

Dependencies

[top of page]

APPS.WIP_SUB_LOC_NET_AVAIL_VIEW references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
ViewMTL_EMPLOYEES_VIEW
ViewMTL_ITEM_FLEXFIELDS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_ONHAND_QUANTITIES_DETAIL
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SYSTEM_ITEMS_B
SynonymWIP_DISCRETE_JOBS
SynonymWIP_REPETITIVE_SCHEDULES
SynonymWIP_REQUIREMENT_OPERATIONS

APPS.WIP_SUB_LOC_NET_AVAIL_VIEW is not referenced by any database object