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

PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. Cost distribution lines amount are implicitly debit amounts.
An expenditure item may have many cost distribution lines if:
1) you account for total burdened costs by running the Distribute Total Burdened Costs process. The cost distribution lines for total burdened costs are identified with the line type of C and D.
2) adjusting cost distribution lines are created due a change in either the cost amount, the GL account, burden cost quantity, burden compiled set identifier or the billable flag.
Adjusting lines are identified with a value in the LINE_NUM_REVERSED column.
The transfer status of a cost distribution lines is maintained as follows:
For labor and usages:
Distribute Costs - Create CDL; set to Pending (P)
Transfer Costs - If successfully transferred to GL, set to
Accepted(A); Else rejected in transfer to GL, set to Rejected in
Transfer (X)
Tieback Costs - If successfully tied back from GL, no update since
already set to Accepted; Else rejected by GL, set to Rejected (R) to
be re-transferred
For expense reports:
Distribute Costs - Create CDL; set to Pending (P)
Transfer Costs - If successfully transferred to Oracle Payables, set
to Transferred (T); Else rejected in transfer to AP; set to Rejected
in Transfer (X)
Tieback Costs - If successfully tied back from Oracle Payables, set
to Accepted(A); Else rejected by Oracle Payables; set to Rejected (R)
to be re-transferred
For supplier invoices from Oracle Payables:
Interface from Oracle Payables - Upon creation, set to Received (V)
For supplier invoice adjustment lines:
Distribute Costs - Create CDL; set to Pending (P)
If payables rules do not allow adjustments to the invoice (example:
if the invoice is cancelled), then distribute supplier invoice
adjustments program would create the CDL and set the value to (G),
these lines will always reside in Oracle Projects and will not
be transferred to Oracle Payables.)
Transfer Costs - If successfully transferred to Oracle Payables,
set to Accepted(A); Else rejected in transfer to Oracle Payables,
set to Rejected in Transfer (X)
No Tieback

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 LINE_TYPE
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_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BURDEN_SUM_SOURCE_RUN_ID IND_COMPILED_SET_ID GL_DATE
PA_COST_DISTRIBUTION_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE REQUEST_ID LINE_TYPE
PA_COST_DISTRIBUTION_LINES_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SI_ASSETS_ADDITION_FLAG
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 LINE_TYPE TRANSFER_STATUS_CODE SI_ASSETS_ADDITION_FLAG
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	The identifier of the expenditure item that is cost distributed by the distribution line
LINE_NUM	NUMBER	(15)	Yes	The sequential number that identifies the cost distribution line for an expenditure item
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
TRANSFER_STATUS_CODE	VARCHAR2	(1)	Yes	The status of the distribution line as the cost information is transferred to another application
BILLABLE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the cost amount is billable. The flag is set from the expenditure item billable flag when the distribution line is created and is used for determining billable/non-billable costs in the accumulation tables
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
PA_DATE	DATE			Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date
DR_CODE_COMBINATION_ID	NUMBER	(15)		The identifier of the GL account to which the cost is charged
GL_DATE	DATE			Date used to determine the correct general ledger accounting period in the provider operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date. For supplier invoices this date is copied from AP.
TRANSFERRED_DATE	DATE			The date the distribution line was transferred to another application
TRANSFER_REJECTION_REASON	VARCHAR2	(250)		The reason why the distribution line was rejected by the PA Cost Transfer program or rejected by the other application's interface program
BATCH_NAME	VARCHAR2	(30)		The reference to a batch of lines transferred together. For expense reports, this is an expenditure batch. For cost transferred to GL, this is a concatenation of liability ccid, gl date, and transfer request id separated by hyphens.
ACCUMULATED_FLAG	VARCHAR2	(1)		Flag indicating if distribution line cost is included in the accumulator tables. Set to 'N' initially, 'Y' when the line is accumulated. Obsolete as of 4.0 with the new project summary amounts. Replaced by RESOURCE_ACCUMULATED_FLAG.
REVERSED_FLAG	VARCHAR2	(1)		Flag that indicates if the distribution line is reversed by another distribution line
LINE_NUM_REVERSED	NUMBER	(15)		The distribution line number that is reversed by this distribution line
SYSTEM_REFERENCE1	VARCHAR2	(30)		The reference to the record in another application when the line is transferred. For supplier invoices, this holds AP_INVOICES.VENDOR_ID. This is not used for other adjustment lines.
SYSTEM_REFERENCE2	VARCHAR2	(30)		The reference to the record in another application when the line is transferred For supplier invoices and expense reports, this holds the AP_INVOICESINVOICE_ID Not used for labor and usages
SYSTEM_REFERENCE3	VARCHAR2	(30)		The reference to the record in another application when the line related to supplier invoice or expense report is transferred. It holds AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER.
CR_CODE_COMBINATION_ID	NUMBER	(15)		The identifier of the GL liability account
IND_COMPILED_SET_ID	NUMBER	(15)		The identifier of the compiled set which is used to calculate the burden cost
LINE_TYPE	VARCHAR2	(1)	Yes	The type of the cost distribution line
RESOURCE_ACCUMULATED_FLAG	VARCHAR2	(1)		Flag to indicate whether this cost distribution line is resource accumulated. The cost distribution line may be accumulated in the current reporting period or future periods. In both cases the resource accum flag will be = 'Y'
FUNCTION_TRANSACTION_CODE	VARCHAR2	(30)		This is a PA 3.0 column
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
CODE_COMBINATION_ID	NUMBER	(15)		Obsolete as of Version 3.1
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(15)		This will identify group of Cost Distribution Lines that were summarized to create summarized burden component expenditure items(EI). The same run_id will be populated in EI table to identify all EI's created during a run.
BURDEN_SUM_REJECTION_CODE	VARCHAR2	(30)		Burden component summarization rejection code
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction Currency code of the transaction
DENOM_RAW_COST	NUMBER			The raw cost in transaction currency
DENOM_BURDENED_COST	NUMBER			The amount of the burdened cost in transaction currency It is only populated for raw cost distribution lines
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Functional Currency Code
ACCT_RATE_DATE	DATE			Conversion rate date used to convert raw cost from transaction currency to functional currency
ACCT_RATE_TYPE	VARCHAR2	(30)		Conversion rate type used to convert raw cost from transaction currency to functional currency
ACCT_EXCHANGE_RATE	NUMBER			Conversion rate used to convert raw cost from transaction currency to functional currency
ACCT_RAW_COST	NUMBER			The amount in functional currency to be charged to the gl account for the expenditure item The amount is stored as a debit, so the burden credit amounts and adjustment amounts are negative
ACCT_BURDENED_COST	NUMBER			Burdened cost in functional currency
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code of the transaction
PROJECT_RATE_DATE	DATE			Conversion rate date used to convert raw cost from transaction currency to project currency
PROJECT_RATE_TYPE	VARCHAR2	(30)		Conversion rate date used to convert raw cost from transaction currency to project currency
PROJECT_EXCHANGE_RATE	NUMBER			Conversion rate date used to convert raw cost from transaction currency to project currency
PROJECT_ID	NUMBER	(15)		Identifier of the project
TASK_ID	NUMBER	(15)		Identifier of the task
PRC_GENERATED_FLAG	VARCHAR2	(1)		For future Use
RECVR_PA_DATE	DATE			Date used to determine the correct project accounting period in the receiver operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date
RECVR_GL_DATE	DATE			Date used to determine the correct general ledgert accounting period in the receiver operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date
UTIL_SUMMARIZED_FLAG	VARCHAR2	(1)		Flag to indicate the summarization status of the line for utilization purposes. Values a re: Y = Summarized N = To be Summarized X = Never Summarized
LIQUIDATE_ENCUM_FLAG	VARCHAR2	(1)		This flag indicates if the encumbrance liquidation is required for the cost distribution line.
ENCUMBRANCE_BATCH_NAME	VARCHAR2	(240)		The batch name used which creating encumbrance liquidation.
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Commitment encumbrance type identifier used during processing.
ENCUM_TRANSFER_REJ_REASON	VARCHAR2	(250)		Reason why the commitment encumbrance liquidation entries was rejected by PA cost transfer program
BUDGET_CCID	NUMBER	(15)		The account of the budget line to which the transaction is mapped.
ENCUMBRANCE_AMOUNT	NUMBER			The amount encumbered when the encumbrance liquidation is created.
PROJFUNC_COST_EXCHANGE_RATE	NUMBER			Exchange rate used to convert costs from the transaction currency to the project functional currency.
PROJECT_RAW_COST	NUMBER			Raw cost in project currency.
PROJECT_BURDENED_COST	NUMBER			Burdened cost in project currency.
WORK_TYPE_ID	NUMBER	(15)		Identifier for a work type assigned to the transaction.
GL_PERIOD_NAME	VARCHAR2	(15)		The GL period in which the transaction is posted.
RECVR_GL_PERIOD_NAME	VARCHAR2	(15)		The GL period in which the transaction is posted on the receiving ledger.
PA_PERIOD_NAME	VARCHAR2	(15)		The PA period in which the transaction is posted.
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert costs from the transaction currency to the project functional currency.
PROJFUNC_COST_RATE_DATE	DATE			Rate date used to convert costs from the transaction currency to the project functional currency.
RECVR_PA_PERIOD_NAME	VARCHAR2	(15)		The PA period in which the transaction is posted on the receiving ledger.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency code.
SYSTEM_REFERENCE4	VARCHAR2	(30)		The reference to the record in another application when the line related to supplier invoice or expense report is transferred. It holds AP_INVOICE_PAYMENTS_ALL. INVOICE_PAYMENT_ID
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)		Indicates whether the record has been summarized by Project Intelligence
ORG_LABOR_SCH_RULE_ID	NUMBER	(15)		Identifier for org schedule assignment
COST_RATE_SCH_ID	NUMBER	(15)		The identifier of the cost rate schedule used during costing.
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
COSTING_METHOD	VARCHAR2	(150)		The method used to cost the expenditure item
RATE_SOURCE_CODE	VARCHAR2	(30)		Name of the source from which employee rates are derived
PAYROLL_ACCRUAL_FLAG	VARCHAR2	(1)		payroll_accrual_flag is 'Flag to indicate if the labor costs are accrued to a project
AMOUNT#1	NUMBER		Yes
QUANTITY#1	NUMBER		Yes
BURDENED_COST#1	NUMBER
CBS_ELEMENT_ID	NUMBER	(15)		Unique id corresponding to the cost code.

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
,      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
,      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
,      AMOUNT#1
,      QUANTITY#1
,      BURDENED_COST#1
,      CBS_ELEMENT_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:

PA: PA_COST_DISTRIBUTION_LINES_AL#