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

VIEW: APPS.PJM_PROJECT_COST_HISTORY_V

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

View Type

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


PJM_PROJECT_COST_HISTORY_V returns item cost history information for the cost group associated with the project.
This view corresponds to the Cost History web inquiry region.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item unique identifier
TRANSACTION_ID NUMBER

Material transaction unique identifier
ORGANIZATION_ID NUMBER

Inventory organization unique identifier
LAYER_ID NUMBER

Actual cost layer unique identifier
TRANSACTION_COSTED_DATE DATE

Date material transaction is costed
TRANSACTION_DATE DATE

Date material transaction occurs
PRIOR_COSTED_QUANTITY NUMBER

Costed quantity before the transaction
PRIMARY_QUANTITY NUMBER

Transaction quantity in primary unit of measure
NEW_QUANTITY NUMBER

New quantity after the transaction
COST_GROUP_ID NUMBER

Cost group unique identifier
TRANSACTION_TYPE VARCHAR2 (80)
Material transaction type
ACTUAL_COST NUMBER

Actual cost
ACTUAL_MATERIAL NUMBER

Material elemental cost
ACTUAL_MATERIAL_OVERHEAD NUMBER

Material overhead elemental cost
ACTUAL_RESOURCE NUMBER

Resource elemental cost
ACTUAL_OUTSIDE_PROCESSING NUMBER

Outside Processing elemental cost
ACTUAL_OVERHEAD NUMBER

Overhead elemental cost
PRIOR_COST NUMBER

Item cost prior to transaction
PRIOR_MATERIAL NUMBER

Material elemental cost prior to transaction
PRIOR_MATERIAL_OVERHEAD NUMBER

Material overhead elemental cost prior to transaction
PRIOR_RESOURCE NUMBER

Resource elemental cost prior to transaction
PRIOR_OUTSIDE_PROCESSING NUMBER

Outside processing elemental cost prior to transaction
PRIOR_OVERHEAD NUMBER

Overhead elemental cost prior to transaction
NEW_COST NUMBER

New item cost
NEW_MATERIAL NUMBER

New material elemental cost
NEW_MATERIAL_OVERHEAD NUMBER

New material overhead elemental cost
NEW_RESOURCE NUMBER

New resource elemental cost
NEW_OUTSIDE_PROCESSING NUMBER

New outside processing elemental cost
NEW_OVERHEAD NUMBER

New overhead elemental cost
CHANGE VARCHAR2 (1)
Cost element change flag
Query Text

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


SELECT INVENTORY_ITEM_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      LAYER_ID
,      TRANSACTION_COSTED_DATE
,      TRANSACTION_DATE
,      PRIOR_COSTED_QUANTITY
,      PRIMARY_QUANTITY
,      NEW_QUANTITY
,      COST_GROUP_ID
,      TRANSACTION_TYPE
,      ACTUAL_COST
,      ACTUAL_MATERIAL
,      ACTUAL_MATERIAL_OVERHEAD
,      ACTUAL_RESOURCE
,      ACTUAL_OUTSIDE_PROCESSING
,      ACTUAL_OVERHEAD
,      PRIOR_COST
,      PRIOR_MATERIAL
,      PRIOR_MATERIAL_OVERHEAD
,      PRIOR_RESOURCE
,      PRIOR_OUTSIDE_PROCESSING
,      PRIOR_OVERHEAD
,      NEW_COST
,      NEW_MATERIAL
,      NEW_MATERIAL_OVERHEAD
,      NEW_RESOURCE
,      NEW_OUTSIDE_PROCESSING
,      NEW_OVERHEAD
,      CHANGE
FROM APPS.PJM_PROJECT_COST_HISTORY_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_COST_HISTORY_V references the following:

SchemaAPPS
ViewCST_CG_COST_HISTORY_V
SynonymFND_CURRENCIES
ViewGL_SETS_OF_BOOKS
SynonymHR_ORGANIZATION_INFORMATION

APPS.PJM_PROJECT_COST_HISTORY_V is not referenced by any database object