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]

VIEW: APPS.PJM_PROJECT_ONHAND_VALUE_V

Object Details

Object Name:	PJM_PROJECT_ONHAND_VALUE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.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	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:

APPS: CST_COST_GROUPS; CST_ITEM_COSTS; CST_QUANTITY_LAYERS; FND_CURRENCIES; FND_CURRENCY_CACHE - show dependent code; GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS_TL; HR_ORGANIZATION_INFORMATION; MTL_ITEM_LOCATIONS; MTL_ONHAND_QUANTITIES; MTL_ONHAND_QUANTITIES_DETAIL; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; PJM_PROJECT_PARAMETERS

APPS.PJM_PROJECT_ONHAND_VALUE_V is not referenced by any database object