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]

VIEW: APPS.PA_CC_DIST_LINES_ALL_MRC_V

Object Details

Object Name:	PA_CC_DIST_LINES_ALL_MRC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_CC_DIST_LINES_ALL_MRC_V
Subobject Name:
Status:	VALID

View Type

A multiple reporting currency view

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCT_TP_EXCHANGE_RATE	NUMBER
ACCT_TP_RATE_DATE	DATE
ACCT_TP_RATE_TYPE	VARCHAR2	(30)
AMOUNT	NUMBER		Yes
BILL_MARKUP_PERCENTAGE	NUMBER
BILL_RATE	NUMBER
CC_DIST_LINE_ID	NUMBER		Yes
CR_CODE_COMBINATION_ID	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CROSS_CHARGE_CODE	VARCHAR2	(1)	Yes
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)
DENOM_TRANSFER_PRICE	NUMBER
DIST_LINE_ID_REVERSED	NUMBER
DR_CODE_COMBINATION_ID	NUMBER
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes
GL_BATCH_NAME	VARCHAR2	(30)
GL_DATE	DATE
IND_COMPILED_SET_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)	Yes
LINE_NUM	NUMBER		Yes
LINE_NUM_REVERSED	NUMBER
LINE_TYPE	VARCHAR2	(2)	Yes
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)
ORG_ID	NUMBER
PA_DATE	DATE
PRC_ASSIGNMENT_ID	NUMBER	(15)	Yes
PROGRAM_APPLICATION_ID	NUMBER	(15)	Yes
PROGRAM_ID	NUMBER	(15)	Yes
PROGRAM_UPDATE_DATE	DATE		Yes
PROJECT_ID	NUMBER		Yes
REFERENCE_1	NUMBER
REFERENCE_2	VARCHAR2	(240)
REFERENCE_3	NUMBER
REQUEST_ID	NUMBER	(15)	Yes
REVERSED_FLAG	VARCHAR2	(1)
RULE_PERCENTAGE	NUMBER
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
SCHEDULE_LINE_PERCENTAGE	NUMBER
TASK_ID	NUMBER		Yes
TP_BASE_AMOUNT	NUMBER
TRANSFER_REJECTION_CODE	VARCHAR2	(30)
TRANSFER_STATUS_CODE	VARCHAR2	(30)	Yes
TRANSFERRED_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)
PROJFUNC_TP_RATE_DATE	DATE
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_TP_EXCHANGE_RATE	NUMBER
PROJFUNC_TRANSFER_PRICE	NUMBER
TP_AMT_TYPE_CODE	VARCHAR2	(30)
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes
ACCT_EVENT_ID	NUMBER	(15)

Query Text

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


SELECT ACCT_TP_EXCHANGE_RATE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_RATE_TYPE
,      AMOUNT
,      BILL_MARKUP_PERCENTAGE
,      BILL_RATE
,      CC_DIST_LINE_ID
,      CR_CODE_COMBINATION_ID
,      CREATED_BY
,      CREATION_DATE
,      CROSS_CHARGE_CODE
,      DENOM_TP_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      DIST_LINE_ID_REVERSED
,      DR_CODE_COMBINATION_ID
,      EXPENDITURE_ITEM_ID
,      GL_BATCH_NAME
,      GL_DATE
,      IND_COMPILED_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LINE_NUM
,      LINE_NUM_REVERSED
,      LINE_TYPE
,      MARKUP_CALC_BASE_CODE
,      ORG_ID
,      PA_DATE
,      PRC_ASSIGNMENT_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REQUEST_ID
,      REVERSED_FLAG
,      RULE_PERCENTAGE
,      SET_OF_BOOKS_ID
,      SCHEDULE_LINE_PERCENTAGE
,      TASK_ID
,      TP_BASE_AMOUNT
,      TRANSFER_REJECTION_CODE
,      TRANSFER_STATUS_CODE
,      TRANSFERRED_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
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJFUNC_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_EVENT_ID
FROM APPS.PA_CC_DIST_LINES_ALL_MRC_V;

Dependencies

[top of page]

APPS.PA_CC_DIST_LINES_ALL_MRC_V references the following:

APPS: PA_CC_DIST_LINES_ALL; PA_MC_CC_DIST_LINES_ALL

APPS.PA_CC_DIST_LINES_ALL_MRC_V is referenced by following:

APPS: PA_AEL_SL_EI_MRC_V