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.PA_OLAP_STAGE_V

Object Details

Object Name:	PA_OLAP_STAGE_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OLAP_GROUP	NUMBER	(15)	Yes	OLAP CUBE Project level partitioning Identifier
PROJECT_ID	NUMBER	(15)	Yes	Project Identifier
PROJECT_ELEMENT_ID	NUMBER			Project Element Identifier
TIME_ID	NUMBER	(15)	Yes	Calendar Period Identifier
CALENDAR_TYPE	VARCHAR2	(1)	Yes	Calendar Type Identifier
CURRENCY_CODE	VARCHAR2	(30)	Yes	XXXX
RBS_ELEMENT_ID	NUMBER			XXXX
RBS_VERSION_ID	NUMBER	(15)	Yes	XXXX
PLAN_VERSION_ID	NUMBER	(15)	Yes	XXXX
LAST_UPDATE_DATE	DATE		Yes	XXXX
LAST_UPDATED_BY	NUMBER	(15)	Yes	XXXX
CREATION_DATE	DATE			XXXX
CREATED_BY	NUMBER	(15)		XXXX
LAST_UPDATE_LOGIN	NUMBER	(15)		XXXX
RAW_COST	NUMBER			XXXX
BRDN_COST	NUMBER			XXXX
REVENUE	NUMBER			XXXX
BILL_RAW_COST	NUMBER			XXXX
BILL_BRDN_COST	NUMBER			XXXX
BILL_LABOR_RAW_COST	NUMBER			XXXX
BILL_LABOR_BRDN_COST	NUMBER			XXXX
BILL_LABOR_HRS	NUMBER			XXXX
EQUIPMENT_RAW_COST	NUMBER			XXXX
EQUIPMENT_BRDN_COST	NUMBER			XXXX
CAPITALIZABLE_RAW_COST	NUMBER			XXXX
CAPITALIZABLE_BRDN_COST	NUMBER			XXXX
LABOR_RAW_COST	NUMBER			XXXX
LABOR_BRDN_COST	NUMBER			XXXX
LABOR_HRS	NUMBER			XXXX
LABOR_REVENUE	NUMBER			XXXX
EQUIPMENT_HOURS	NUMBER			XXXX
BILLABLE_EQUIPMENT_HOURS	NUMBER			XXXX
SUP_INV_COMMITTED_COST	NUMBER			XXXX
PO_COMMITTED_COST	NUMBER			XXXX
PR_COMMITTED_COST	NUMBER			XXXX
OTH_COMMITTED_COST	NUMBER			XXXX
CUSTOM1	NUMBER			XXXX
CUSTOM2	NUMBER			XXXX
CUSTOM3	NUMBER			XXXX
CUSTOM4	NUMBER			XXXX
CUSTOM5	NUMBER			XXXX
CUSTOM6	NUMBER			XXXX
CUSTOM7	NUMBER			XXXX
CUSTOM8	NUMBER			XXXX
CUSTOM9	NUMBER			XXXX
CUSTOM10	NUMBER			XXXX
CUSTOM11	NUMBER			XXXX
CUSTOM12	NUMBER			XXXX
CUSTOM13	NUMBER			XXXX
CUSTOM14	NUMBER			XXXX
CUSTOM15	NUMBER			XXXX
ACT_LABOR_HRS	NUMBER			XXXX
ACT_EQUIP_HRS	NUMBER			XXXX
ACT_LABOR_BRDN_COST	NUMBER			XXXX
ACT_EQUIP_BRDN_COST	NUMBER			XXXX
ACT_BRDN_COST	NUMBER			XXXX
ACT_RAW_COST	NUMBER			XXXX
ACT_REVENUE	NUMBER			XXXX
ETC_LABOR_HRS	NUMBER			XXXX
ETC_EQUIP_HRS	NUMBER			XXXX
ETC_LABOR_BRDN_COST	NUMBER			XXXX
ETC_EQUIP_BRDN_COST	NUMBER			XXXX
ETC_BRDN_COST	NUMBER			XXXX
ETC_RAW_COST	NUMBER			XXXX
ACT_LABOR_RAW_COST	NUMBER			XXXX
ACT_EQUIP_RAW_COST	NUMBER			XXXX
ETC_LABOR_RAW_COST	NUMBER			XXXX
ETC_EQUIP_RAW_COST	NUMBER			XXXX
CBS_VERSION_ID	NUMBER			XXXX
CBS_ELEMENT_ID	NUMBER			XXXX

Query Text

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


SELECT OLAP_GROUP
,      PROJECT_ID
,      PROJECT_ELEMENT_ID
,      TIME_ID
,      CALENDAR_TYPE
,      CURRENCY_CODE
,      RBS_ELEMENT_ID
,      RBS_VERSION_ID
,      PLAN_VERSION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RAW_COST
,      BRDN_COST
,      REVENUE
,      BILL_RAW_COST
,      BILL_BRDN_COST
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BRDN_COST
,      BILL_LABOR_HRS
,      EQUIPMENT_RAW_COST
,      EQUIPMENT_BRDN_COST
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_BRDN_COST
,      LABOR_RAW_COST
,      LABOR_BRDN_COST
,      LABOR_HRS
,      LABOR_REVENUE
,      EQUIPMENT_HOURS
,      BILLABLE_EQUIPMENT_HOURS
,      SUP_INV_COMMITTED_COST
,      PO_COMMITTED_COST
,      PR_COMMITTED_COST
,      OTH_COMMITTED_COST
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
,      ACT_LABOR_HRS
,      ACT_EQUIP_HRS
,      ACT_LABOR_BRDN_COST
,      ACT_EQUIP_BRDN_COST
,      ACT_BRDN_COST
,      ACT_RAW_COST
,      ACT_REVENUE
,      ETC_LABOR_HRS
,      ETC_EQUIP_HRS
,      ETC_LABOR_BRDN_COST
,      ETC_EQUIP_BRDN_COST
,      ETC_BRDN_COST
,      ETC_RAW_COST
,      ACT_LABOR_RAW_COST
,      ACT_EQUIP_RAW_COST
,      ETC_LABOR_RAW_COST
,      ETC_EQUIP_RAW_COST
,      CBS_VERSION_ID
,      CBS_ELEMENT_ID
FROM APPS.PA_OLAP_STAGE_V;

Dependencies

[top of page]

APPS.PA_OLAP_STAGE_V references the following:

APPS: PA_OLAP_STAGE

APPS.PA_OLAP_STAGE_V is not referenced by any database object