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]

TABLE: PA.PA_COST_DISTRIBUTION_LINES_ALL

Object Details

Object Name:	PA_COST_DISTRIBUTION_LINES_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_COST_DISTRIBUTION_LINES_ALL
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_COST_DISTRIBUTION_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID LINE_NUM
PA_COST_DISTRIBUTION_LINES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BURDEN_SUM_SOURCE_RUN_ID PROJECT_ID
PA_COST_DISTRIBUTION_LINES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID LINE_TYPE RESOURCE_ACCUMULATED_FLAG
PA_COST_DISTRIBUTION_LINES_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_REFERENCE1 LINE_NUM
PA_COST_DISTRIBUTION_LINES_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID LINE_TYPE PJI_SUMMARIZED_FLAG
PA_COST_DISTRIBUTION_LINES_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_LABOR_SCH_RULE_ID COST_RATE_SCH_ID
PA_COST_DISTRIBUTION_LINES_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCT_EVENT_ID
PA_COST_DISTRIBUTION_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE REQUEST_ID
PA_COST_DISTRIBUTION_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_NAME DR_CODE_COMBINATION_ID
PA_COST_DISTRIBUTION_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
PA_COST_DISTRIBUTION_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_REFERENCE2 SYSTEM_REFERENCE3 SYSTEM_REFERENCE1
PA_COST_DISTRIBUTION_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCUMULATED_FLAG
PA_COST_DISTRIBUTION_LINES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PA_DATE
PA_COST_DISTRIBUTION_LINES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_DATE
PA_COST_DISTRIBUTION_LINES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IND_COMPILED_SET_ID

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	(22)	Yes
QUANTITY	NUMBER	(22)	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	(22)
RESOURCE_ACCUMULATED_FLAG	VARCHAR2	(1)
FUNCTION_TRANSACTION_CODE	VARCHAR2	(30)		This is a PA 3.0 column
ORG_ID	NUMBER	(15)
CODE_COMBINATION_ID	NUMBER	(15)		Obsolete as of Version 3.1
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)		This column indicates the status of the cost distribution line in relation to Oracle Assets. This column only applies to supplier cost expenditure items. Valid values are as follows:Y - The distribution line is interfaced to Oracle Assets.N - The distribution line is not eligible to be interfaced to Oracle Assets.T - The distribution line is pending interface to Oracle Assets.
SYSTEM_REFERENCE5	NUMBER	(15)		This column refers to a record in another application. When the cost distribution line is related to Oracle Payables transactions, it holds AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_DISTRIBUTION_ID. When the cost distribution line is related to manufacturing or receiving transactions, it holds the debit subledger identifier. This column is not used for labor or usage transactions.
ACCT_EVENT_ID	NUMBER	(15)		Identifier of Accounting Event
ACCT_SOURCE_CODE	VARCHAR2	(10)		Code used to identify accounting transactions, which are not migrated to SLA
BUDGET_LINE_ID	NUMBER	(15)		Identifier of the budget line used for encumbrance accounting
BUDGET_VERSION_ID	NUMBER	(15)		Identifier of the budget version used for encumbrance accounting

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
FROM PA.PA_COST_DISTRIBUTION_LINES_ALL;

Dependencies

[top of page]

PA.PA_COST_DISTRIBUTION_LINES_ALL does not reference any database object

PA.PA_COST_DISTRIBUTION_LINES_ALL is referenced by following:

APPS: PA_COST_DISTRIBUTION_LINES; PA_COST_DISTRIBUTION_LINES_ALL