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
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
Name Datatype Length Mandatory Comments
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