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


VIEW: APPS.PJM_PROJECT_ONHAND_VALUE_V

Object Details
Object Name: PJM_PROJECT_ONHAND_VALUE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJM.PJM_PROJECT_ONHAND_VALUE_V
Subobject Name:
Status: VALID

View Type

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


PJM_PROJECT_ONHAND_VALUE_V returns inventory onhand valuation information for each project.
This view corresponds to the Onhand Values web inquiry region.
This view is a union of two parts. The first part returns inventory onhand valuation for average costing organizations, while the second part returns valuation for standard costing organizations. This union is necessary as the item cost information for the two costing methods is stored under different set of tables.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
System-generated number that uniquely identifies a project or seiban
COST_GROUP_ID NUMBER

Cost group unique identifier
COST_GROUP_NAME VARCHAR2 (10)
Cost group name
COST_GROUP_DESCRIPTION VARCHAR2 (240)
Cost group description
ORGANIZATION_ID NUMBER

Inventory organization unique identifier
ORGANIZATION_NAME VARCHAR2 (240)
Inventory organization name
INVENTORY_ITEM_ID NUMBER

Inventory item unique identifier
ITEM_NUMBER VARCHAR2 (40)
Item number
CURRENCY_CODE VARCHAR2 (15)
Currency code
QUANTITY_ONHAND NUMBER

Quantity onhand
UNIT_COST NUMBER

Unit cost
TOT_INVENTORY_VALUE VARCHAR2 (4000)
Total inventory value for item in cost group
TOT_MATERIAL_VALUE VARCHAR2 (4000)
Total material elemental value for item in cost group
TOT_MATERIAL_OVERHEAD_VALUE VARCHAR2 (4000)
Total material overhead elemental value for item in cost group
TOT_RESOURCE_VALUE VARCHAR2 (4000)
Total resource elemental value for item in cost group
TOT_OUTSIDE_PROCESSING_VALUE VARCHAR2 (4000)
Total outside processing elemental value for item in cost group
TOT_OVERHEAD_VALUE VARCHAR2 (4000)
Total overhead elemental value for item in cost group
Query Text

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


SELECT PROJECT_ID
,      COST_GROUP_ID
,      COST_GROUP_NAME
,      COST_GROUP_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      CURRENCY_CODE
,      QUANTITY_ONHAND
,      UNIT_COST
,      TOT_INVENTORY_VALUE
,      TOT_MATERIAL_VALUE
,      TOT_MATERIAL_OVERHEAD_VALUE
,      TOT_RESOURCE_VALUE
,      TOT_OUTSIDE_PROCESSING_VALUE
,      TOT_OVERHEAD_VALUE
FROM APPS.PJM_PROJECT_ONHAND_VALUE_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_ONHAND_VALUE_V references the following:

SchemaAPPS
SynonymCST_COST_GROUPS
SynonymCST_ITEM_COSTS
SynonymCST_QUANTITY_LAYERS
SynonymFND_CURRENCIES
PL/SQL PackageFND_CURRENCY_CACHE - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ORGANIZATION_INFORMATION
SynonymMTL_ITEM_LOCATIONS
ViewMTL_ONHAND_QUANTITIES
SynonymMTL_ONHAND_QUANTITIES_DETAIL
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPJM_PROJECT_PARAMETERS

APPS.PJM_PROJECT_ONHAND_VALUE_V is not referenced by any database object