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_CC_DIST_LINES_ALL

Object Details

Object Name:	PA_CC_DIST_LINES_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_CC_DIST_LINES_ALL
Subobject Name:
Status:	VALID

PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. This information will be interfaced to Oracle General Ledger from Oracle Projects.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_CC_DIST_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CC_DIST_LINE_ID
PA_CC_DIST_LINES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID LINE_TYPE LINE_NUM
PA_CC_DIST_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID
PA_CC_DIST_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID TRANSFER_STATUS_CODE
PA_CC_DIST_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE
PA_CC_DIST_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCT_EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CC_DIST_LINE_ID	NUMBER		Yes	The system-generated number that uniquely identifies the cross charge distribution
EXPENDITURE_ITEM_ID	NUMBER		Yes	The identifier of the expenditure item to which the cross charge distribution belongs
LINE_NUM	NUMBER		Yes	The sequential line number that identifies the cross charge distribution line for an expenditure item
LINE_TYPE	VARCHAR2	(2)	Yes	The type of the cross charge distribution line
CROSS_CHARGE_CODE	VARCHAR2	(1)	Yes	Indicates the cross charge processing method for the expenditure item.
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional currency code of the operating unit to which the cross charge distribution belongs
AMOUNT	NUMBER		Yes	Amount to be posted to GL in the functional currency. If the line type is Borrowed or Lent, the amount is transfer price. If the line type is Provider Reclass, the amount is raw cost
PROJECT_ID	NUMBER		Yes	Identifier of the project to which the expenditure item belongs. Denormalized column
TASK_ID	NUMBER		Yes	Identifier of the task to which the expenditure item belongs. Denormalized column
REQUEST_ID	NUMBER		Yes	Identifier of the concurrent program that last processed the item
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
ORG_ID	NUMBER			Identifier of the operating unit to which the cross charge distribution belongs
LINE_NUM_REVERSED	NUMBER			The distribution line number for the same expenditure item that is reversed by this distribution line
DIST_LINE_ID_REVERSED	NUMBER			Identifier of the cross charge distribution that the line reverses .
REVERSED_FLAG	VARCHAR2	(1)		Indicates whether the line has been reversed
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code of the transfer price
DENOM_TRANSFER_PRICE	NUMBER			Transaction amount of the transfer price
ACCT_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert the transfer price amount from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price
ACCT_TP_RATE_DATE	DATE			Rate date used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit. Derived from the implementation options currency rate date code for transfer price conversion
ACCT_TP_EXCHANGE_RATE	NUMBER			Exchange rate used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit
DR_CODE_COMBINATION_ID	NUMBER			Identifier of the GL debit account for the distribution
CR_CODE_COMBINATION_ID	NUMBER			Identifier of the GL credit account for the distribution
PA_DATE	DATE			The end date of the PA Period in which the distribution was processed. The PA date is determined by the cross charge process from the open or future PA period on or after the expenditure item date
GL_DATE	DATE			The end date of the GL accounting period to which the distribution is posted. This date is determined by the transfer program from the first open or future GL period on or after the distributions PA date
GL_BATCH_NAME	VARCHAR2	(30)		The reference to a batch of lines transferred together. This is a concatenation of the liability code combination identifier, GL Date and Transfer request identifier separated by hyphens
TRANSFER_STATUS_CODE	VARCHAR2	(30)		The status of the distribution line as the accounting information is transferred to GL.
TRANSFERRED_DATE	DATE			The date the record was transferred to GL
TRANSFER_REJECTION_CODE	VARCHAR2	(50)		Rejection code if the record is rejected in transfer to GL.
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)		Audit column for transfer price derivation, thus only for borrowed and lent entries. Transaction amount on which the cross charge rate will be based.
IND_COMPILED_SET_ID	NUMBER			Audit column for transfer price derivation, thus only for borrowed and lent entries. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price.
BILL_RATE	NUMBER			Audit column for transfer price derivation, thus only for borrowed and lent entries. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule
TP_BASE_AMOUNT	NUMBER			Audit column for transfer price derivation, thus only for borrowed and lent entries. Base amount used to derive the transfer price, held in transfer price transaction currency
BILL_MARKUP_PERCENTAGE	NUMBER			Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule
SCHEDULE_LINE_PERCENTAGE	NUMBER			Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the schedule line
RULE_PERCENTAGE	NUMBER			Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the rule definition
REFERENCE_1	NUMBER			The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the Invoice Detail identifier
REFERENCE_2	VARCHAR2	(240)		The reference to a record in another entity in Oracle Projects For Provider reclassification entries, this contains the source of the amount which may be either the raw cost or the burdened cost
PROGRAM_APPLICATION_ID	NUMBER			This column is updated by the program application id when a concurrent program is run.
PROGRAM_ID	NUMBER			This column is updated by the program id when a concurrent program is run.
PROGRAM_UPDATE_DATE	DATE			This column is updated by the sysdate when a concurrent program is run.
REFERENCE_3	NUMBER			The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the line number of the corresponding cost distribution line
TP_JOB_ID	NUMBER	(15)		Identifies the Job for the transaction for which the Transfer Price is based on.
PROJFUNC_TP_EXCHANGE_RATE	NUMBER			Exchange rate used to convert the transfer price from the transaction currency to the project functional currency.
PROJFUNC_TRANSFER_PRICE	NUMBER			Transfer price in project functional currency.
TP_AMT_TYPE_CODE	VARCHAR2	(30)		Cross charge classification.
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert the transfer price from the transaction currency to the project functional currency.
PROJFUNC_TP_RATE_DATE	DATE			Rate date used to convert the transfer price from the transaction currency to the project functional currency.
GL_PERIOD_NAME	VARCHAR2	(15)		The GL period in which the transaction is posted.
PA_PERIOD_NAME	VARCHAR2	(15)		The PA period in which the transaction is posted.
PROJECT_TP_CURRENCY_CODE	VARCHAR2	(15)		Project Currency code
PROJECT_TP_RATE_DATE	DATE			Rate date used to convert the transfer price from the transaction currency to the project currency.
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert the transfer price from the transaction currency to the project currency.
PROJECT_TP_EXCHANGE_RATE	NUMBER			Exchange rate used to convert the transfer price from the transaction the currency to project currency.
PROJECT_TRANSFER_PRICE	NUMBER			Transfer price in project currency
PROJFUNC_TP_CURRENCY_CODE	VARCHAR2	(15)		Project functional Currency.
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

Query Text

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


SELECT CC_DIST_LINE_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      LINE_TYPE
,      CROSS_CHARGE_CODE
,      ACCT_CURRENCY_CODE
,      AMOUNT
,      PROJECT_ID
,      TASK_ID
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      LINE_NUM_REVERSED
,      DIST_LINE_ID_REVERSED
,      REVERSED_FLAG
,      DENOM_TP_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      ACCT_TP_RATE_TYPE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_EXCHANGE_RATE
,      DR_CODE_COMBINATION_ID
,      CR_CODE_COMBINATION_ID
,      PA_DATE
,      GL_DATE
,      GL_BATCH_NAME
,      TRANSFER_STATUS_CODE
,      TRANSFERRED_DATE
,      TRANSFER_REJECTION_CODE
,      MARKUP_CALC_BASE_CODE
,      IND_COMPILED_SET_ID
,      BILL_RATE
,      TP_BASE_AMOUNT
,      BILL_MARKUP_PERCENTAGE
,      SCHEDULE_LINE_PERCENTAGE
,      RULE_PERCENTAGE
,      REFERENCE_1
,      REFERENCE_2
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REFERENCE_3
,      TP_JOB_ID
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJFUNC_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_RATE_DATE
,      GL_PERIOD_NAME
,      PA_PERIOD_NAME
,      PROJECT_TP_CURRENCY_CODE
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      PROJFUNC_TP_CURRENCY_CODE
,      ACCT_EVENT_ID
,      ACCT_SOURCE_CODE
FROM PA.PA_CC_DIST_LINES_ALL;

Dependencies

[top of page]

PA.PA_CC_DIST_LINES_ALL does not reference any database object

PA.PA_CC_DIST_LINES_ALL is referenced by following:

PA: PA_CC_DIST_LINES_ALL#