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

VIEW: PA.PA_CI_DIRECT_COST_DETAILS#

Object Details
Object Name: PA_CI_DIRECT_COST_DETAILS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DC_LINE_ID NUMBER
Yes
CI_ID NUMBER
Yes
PROJECT_ID NUMBER
Yes
TASK_ID NUMBER
Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
RESOURCE_LIST_MEMBER_ID NUMBER
Yes
UNIT_OF_MEASURE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (30)
QUANTITY NUMBER

PLANNING_RESOURCE_RATE NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

RAW_COST_RATE NUMBER

BURDEN_COST_RATE NUMBER

RESOURCE_ASSIGNMENT_ID NUMBER

EFFECTIVE_FROM DATE

EFFECTIVE_TO DATE

CHANGE_REASON_CODE VARCHAR2 (30)
CHANGE_DESCRIPTION VARCHAR2 (2000)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
Query Text

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


SELECT DC_LINE_ID
,      CI_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      RESOURCE_LIST_MEMBER_ID
,      UNIT_OF_MEASURE
,      CURRENCY_CODE
,      QUANTITY
,      PLANNING_RESOURCE_RATE
,      RAW_COST
,      BURDENED_COST
,      RAW_COST_RATE
,      BURDEN_COST_RATE
,      RESOURCE_ASSIGNMENT_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      CHANGE_REASON_CODE
,      CHANGE_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM PA.PA_CI_DIRECT_COST_DETAILS#;

Dependencies

[top of page]

PA.PA_CI_DIRECT_COST_DETAILS# references the following:

SchemaPA
TablePA_CI_DIRECT_COST_DETAILS
PA.PA_CI_DIRECT_COST_DETAILS# is referenced by following:

SchemaAPPS
SynonymPA_CI_DIRECT_COST_DETAILS