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

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_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
EXPENDITURE_ITEM_ID	NUMBER		Yes
LINE_NUM	NUMBER		Yes
LINE_TYPE	VARCHAR2	(2)	Yes
CROSS_CHARGE_CODE	VARCHAR2	(1)	Yes
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT	NUMBER		Yes
PROJECT_ID	NUMBER		Yes
TASK_ID	NUMBER		Yes
REQUEST_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ORG_ID	NUMBER
LINE_NUM_REVERSED	NUMBER
DIST_LINE_ID_REVERSED	NUMBER
REVERSED_FLAG	VARCHAR2	(1)
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)
DENOM_TRANSFER_PRICE	NUMBER
ACCT_TP_RATE_TYPE	VARCHAR2	(30)
ACCT_TP_RATE_DATE	DATE
ACCT_TP_EXCHANGE_RATE	NUMBER
DR_CODE_COMBINATION_ID	NUMBER
CR_CODE_COMBINATION_ID	NUMBER
PA_DATE	DATE
GL_DATE	DATE
GL_BATCH_NAME	VARCHAR2	(30)
TRANSFER_STATUS_CODE	VARCHAR2	(30)
TRANSFERRED_DATE	DATE
TRANSFER_REJECTION_CODE	VARCHAR2	(30)
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)
IND_COMPILED_SET_ID	NUMBER
BILL_RATE	NUMBER
TP_BASE_AMOUNT	NUMBER
BILL_MARKUP_PERCENTAGE	NUMBER
SCHEDULE_LINE_PERCENTAGE	NUMBER
RULE_PERCENTAGE	NUMBER
REFERENCE_1	NUMBER
REFERENCE_2	VARCHAR2	(240)
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
REFERENCE_3	NUMBER
TP_JOB_ID	NUMBER	(15)
PROJFUNC_TP_EXCHANGE_RATE	NUMBER
PROJFUNC_TRANSFER_PRICE	NUMBER
TP_AMT_TYPE_CODE	VARCHAR2	(30)
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_TP_RATE_DATE	DATE
GL_PERIOD_NAME	VARCHAR2	(15)
PA_PERIOD_NAME	VARCHAR2	(15)
PROJECT_TP_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_TP_RATE_DATE	DATE
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)
PROJECT_TP_EXCHANGE_RATE	NUMBER
PROJECT_TRANSFER_PRICE	NUMBER
PROJFUNC_TP_CURRENCY_CODE	VARCHAR2	(15)
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:

APPS: PA_CC_DIST_LINES; PA_CC_DIST_LINES_ALL