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

VIEW: PA.PA_COST_DISTRIBUTION_LINES_AL#

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_ITEM_ID NUMBER (15) Yes
LINE_NUM NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
TRANSFER_STATUS_CODE VARCHAR2 (1) Yes
AMOUNT NUMBER
Yes
QUANTITY NUMBER
Yes
BILLABLE_FLAG VARCHAR2 (1) Yes
REQUEST_ID NUMBER (15)

PROGRAM_APPLICATION_ID NUMBER (15)

PROGRAM_ID NUMBER (15)

PROGRAM_UPDATE_DATE DATE


PA_DATE DATE


DR_CODE_COMBINATION_ID NUMBER (15)

GL_DATE DATE


TRANSFERRED_DATE DATE


TRANSFER_REJECTION_REASON VARCHAR2 (250)

BATCH_NAME VARCHAR2 (30)

ACCUMULATED_FLAG VARCHAR2 (1)

REVERSED_FLAG VARCHAR2 (1)

LINE_NUM_REVERSED NUMBER (15)

SYSTEM_REFERENCE1 VARCHAR2 (30)

SYSTEM_REFERENCE2 VARCHAR2 (30)

SYSTEM_REFERENCE3 VARCHAR2 (30)

CR_CODE_COMBINATION_ID NUMBER (15)

IND_COMPILED_SET_ID NUMBER (15)

LINE_TYPE VARCHAR2 (1) Yes
BURDENED_COST NUMBER


RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1)

FUNCTION_TRANSACTION_CODE VARCHAR2 (30)
ORG_ID NUMBER (15)

CODE_COMBINATION_ID NUMBER (15)
BURDEN_SUM_SOURCE_RUN_ID NUMBER (15)
Burdend Summarization Run Id
BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
Burdend Summarization rejection code
DENOM_CURRENCY_CODE VARCHAR2 (15)
Denomination currency code of the transaction
DENOM_RAW_COST NUMBER

Raw cost in denomination currency
DENOM_BURDENED_COST NUMBER

Burdened cost in Denomination currency
ACCT_CURRENCY_CODE VARCHAR2 (15)
Account currency code of the transaction
ACCT_RATE_DATE DATE

Accounting rate date for the transaction
ACCT_RATE_TYPE VARCHAR2 (30)
Accounting rate type for the transaction
ACCT_EXCHANGE_RATE NUMBER

Accounting exchange rate for the transaction
ACCT_RAW_COST NUMBER

Raw cost in accounting currency
ACCT_BURDENED_COST NUMBER

Burdened cost in Accounting currency
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code of the transaction
PROJECT_RATE_DATE DATE

Project rate date for the transaction
PROJECT_RATE_TYPE VARCHAR2 (30)
Project rate type for the transaction
PROJECT_EXCHANGE_RATE NUMBER

Project exchange rate for the transaction
PROJECT_ID NUMBER (15)
Project Id
TASK_ID NUMBER (15)
Task Id
PRC_GENERATED_FLAG VARCHAR2 (1)
RECVR_PA_DATE DATE


RECVR_GL_DATE DATE


UTIL_SUMMARIZED_FLAG VARCHAR2 (1)
LIQUIDATE_ENCUM_FLAG VARCHAR2 (1)
ENCUMBRANCE_BATCH_NAME VARCHAR2 (240)
ENCUMBRANCE_TYPE_ID NUMBER (15)
ENCUM_TRANSFER_REJ_REASON VARCHAR2 (250)
BUDGET_CCID NUMBER (15)
ENCUMBRANCE_AMOUNT NUMBER

PROJFUNC_COST_EXCHANGE_RATE NUMBER

Project functional cost exchange rate
PROJECT_RAW_COST NUMBER

Project Raw Cost
PROJECT_BURDENED_COST NUMBER

Proejct Burdened Cost
WORK_TYPE_ID NUMBER (15)
Identifier of the Work type
GL_PERIOD_NAME VARCHAR2 (15)
GL Period Name
RECVR_GL_PERIOD_NAME VARCHAR2 (15)
Receiver GL Period Name
PA_PERIOD_NAME VARCHAR2 (15)
PA Period Name
PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
Project functional cost rate type
PROJFUNC_COST_RATE_DATE DATE

Project functional cost rate date
RECVR_PA_PERIOD_NAME VARCHAR2 (15)
Receiver PA Period Name
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project functional currency code
SYSTEM_REFERENCE4 VARCHAR2 (30)
PJI_SUMMARIZED_FLAG VARCHAR2 (1)
ORG_LABOR_SCH_RULE_ID NUMBER (15)
Unique key that identifies the labor costing rule and rate schedule used to derive the cost
COST_RATE_SCH_ID NUMBER (15)
The cost rate schedule used to derive cost rate for the transaction
DENOM_BURDENED_CHANGE NUMBER

Change in burdened cost since last time distribution lines were created. Stored in transaction currency.
PROJECT_BURDENED_CHANGE NUMBER

Change in burdened cost since last time the distribution lines were created. Stored in project currency.
PROJFUNC_BURDENED_CHANGE NUMBER

Change in burdened cost since last time distribution lines were created. Stored in project functional currency.
ACCT_BURDENED_CHANGE NUMBER

Change in burdened cost since last time distribution lines were created. Stored in functional currency.
PARENT_LINE_NUM NUMBER (15)
Line Number for the raw cost distribution line. Valid for I line types only.
PREV_IND_COMPILED_SET_ID NUMBER (15)
Identifier of the compiled set previously used to calculate the burden cost.
SI_ASSETS_ADDITION_FLAG VARCHAR2 (1)
SYSTEM_REFERENCE5 NUMBER (15)
ACCT_EVENT_ID NUMBER (15)
ACCT_SOURCE_CODE VARCHAR2 (10)
BUDGET_LINE_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
COSTING_METHOD VARCHAR2 (150)
RATE_SOURCE_CODE VARCHAR2 (30)
PAYROLL_ACCRUAL_FLAG VARCHAR2 (1)
CBS_ELEMENT_ID NUMBER (15)
Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      LINE_NUM
,      CREATION_DATE
,      CREATED_BY
,      TRANSFER_STATUS_CODE
,      AMOUNT
,      QUANTITY
,      BILLABLE_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PA_DATE
,      DR_CODE_COMBINATION_ID
,      GL_DATE
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_REASON
,      BATCH_NAME
,      ACCUMULATED_FLAG
,      REVERSED_FLAG
,      LINE_NUM_REVERSED
,      SYSTEM_REFERENCE1
,      SYSTEM_REFERENCE2
,      SYSTEM_REFERENCE3
,      CR_CODE_COMBINATION_ID
,      IND_COMPILED_SET_ID
,      LINE_TYPE
,      BURDENED_COST
,      RESOURCE_ACCUMULATED_FLAG
,      FUNCTION_TRANSACTION_CODE
,      ORG_ID
,      CODE_COMBINATION_ID
,      BURDEN_SUM_SOURCE_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      PROJECT_ID
,      TASK_ID
,      PRC_GENERATED_FLAG
,      RECVR_PA_DATE
,      RECVR_GL_DATE
,      UTIL_SUMMARIZED_FLAG
,      LIQUIDATE_ENCUM_FLAG
,      ENCUMBRANCE_BATCH_NAME
,      ENCUMBRANCE_TYPE_ID
,      ENCUM_TRANSFER_REJ_REASON
,      BUDGET_CCID
,      ENCUMBRANCE_AMOUNT
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      WORK_TYPE_ID
,      GL_PERIOD_NAME
,      RECVR_GL_PERIOD_NAME
,      PA_PERIOD_NAME
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      RECVR_PA_PERIOD_NAME
,      PROJFUNC_CURRENCY_CODE
,      SYSTEM_REFERENCE4
,      PJI_SUMMARIZED_FLAG
,      ORG_LABOR_SCH_RULE_ID
,      COST_RATE_SCH_ID
,      DENOM_BURDENED_CHANGE
,      PROJECT_BURDENED_CHANGE
,      PROJFUNC_BURDENED_CHANGE
,      ACCT_BURDENED_CHANGE
,      PARENT_LINE_NUM
,      PREV_IND_COMPILED_SET_ID
,      SI_ASSETS_ADDITION_FLAG
,      SYSTEM_REFERENCE5
,      ACCT_EVENT_ID
,      ACCT_SOURCE_CODE
,      BUDGET_LINE_ID
,      BUDGET_VERSION_ID
,      COSTING_METHOD
,      RATE_SOURCE_CODE
,      PAYROLL_ACCRUAL_FLAG
,      CBS_ELEMENT_ID
FROM PA.PA_COST_DISTRIBUTION_LINES_AL#;

Dependencies

[top of page]

PA.PA_COST_DISTRIBUTION_LINES_AL# references the following:

SchemaPA
TablePA_COST_DISTRIBUTION_LINES_ALL
PA.PA_COST_DISTRIBUTION_LINES_AL# is referenced by following:

SchemaAPPS
SynonymPA_COST_DISTRIBUTION_LINES
SynonymPA_COST_DISTRIBUTION_LINES_ALL