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_BL_CUR_SEL_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
EXP_ITEM_ROWID	VARCHAR2	(18)
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)	Yes
CALC_TP_FLAG	VARCHAR2	(1)
ADJUSTED_EXP_ITEM_ID	NUMBER	(15)
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes
TASK_ID	NUMBER	(15)	Yes
EXPENDITURE_ITEM_DATE	DATE		Yes
NET_ZERO_FLAG	VARCHAR2	(1)
QUANTITY	NUMBER
BILLABLE_FLAG	VARCHAR2	(1)	Yes
NL_RESOURCE_ORGANIZATION_ID	NUMBER	(15)
NL_ORGANIZATION_NAME	VARCHAR2	(240)
PRVDR_ORGANIZATION_ID	NUMBER
RECVR_ORGANIZATION_ID	NUMBER
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_TRANSFER_PRICE	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)
ACCT_TP_RATE_TYPE	VARCHAR2	(30)
ACCT_TP_RATE_DATE	DATE
ACCT_TP_EXCHANGE_RATE	NUMBER
ACCT_TRANSFER_PRICE	NUMBER
PROJ_CURRENCY_CODE	VARCHAR2	(15)
CROSS_CHARGE_CODE	VARCHAR2	(1)	Yes
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
REVENUE_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes
JOB_ID	NUMBER	(15)
EXPENDITURE_GROUP	VARCHAR2	(240)	Yes
EXPENDITURE_ENDING_DATE	DATE		Yes
PA_DATE	DATE
EXPENDITURE_ORGANIZATION_ID	NUMBER
EXPENDITURE_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
TASK_ORGANIZATION_ID	NUMBER	(15)	Yes
TASK_NUMBER	VARCHAR2	(25)	Yes
REVENUE_CATEGORY	VARCHAR2	(30)	Yes
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes
NON_LABOR_RESOURCE	VARCHAR2	(20)
PROJ_ORGANIZATION_ID	NUMBER	(15)	Yes
PROJ_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
TASK_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
TASK_SERVICE_TYPE	VARCHAR2	(30)
PROJECT_TYPE	VARCHAR2	(20)	Yes
PROJECT_NUMBER	VARCHAR2	(25)	Yes
PRVDR_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
RECVR_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
RECVR_ORG_ID	NUMBER	(15)
RECVR_ORG_NAME	VARCHAR2	(240)	Yes
EMPLOYEE_NUMBER	VARCHAR2	(30)
PERSON_ID	NUMBER	(10)
TP_SCHEDULE_ID	NUMBER
TP_FIXED_DATE	DATE
TP_IND_COMPILED_SET_ID	NUMBER
TP_BILL_RATE	NUMBER
TP_BILL_MARKUP_PERCENTAGE	NUMBER
TP_SCHEDULE_LINE_PERCENTAGE	NUMBER
TP_RULE_PERCENTAGE	NUMBER
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)
TP_BASE_AMOUNT	NUMBER
DENOM_RAW_COST	NUMBER
DENOM_BURDENED_COST	NUMBER
RAW_REVENUE	NUMBER	(22)
LABOR_NON_LABOR_FLAG	VARCHAR2	(1)	Yes
FN_TRN_CODE_BORR	VARCHAR2	(30)
FN_TRN_NUM_BORR	NUMBER
FN_TRN_CODE_LENT	VARCHAR2	(30)
FN_TRN_NUM_LENT	NUMBER
ORG_ID	NUMBER	(15)

Query Text

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


SELECT EXP_ITEM_ROWID
,      EXPENDITURE_ITEM_ID
,      PROJECT_ID
,      CALC_TP_FLAG
,      ADJUSTED_EXP_ITEM_ID
,      SYSTEM_LINKAGE_FUNCTION
,      TASK_ID
,      EXPENDITURE_ITEM_DATE
,      NET_ZERO_FLAG
,      QUANTITY
,      BILLABLE_FLAG
,      NL_RESOURCE_ORGANIZATION_ID
,      NL_ORGANIZATION_NAME
,      PRVDR_ORGANIZATION_ID
,      RECVR_ORGANIZATION_ID
,      DENOM_TP_CURRENCY_CODE
,      DENOM_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      ACCT_CURRENCY_CODE
,      ACCT_TP_RATE_TYPE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_EXCHANGE_RATE
,      ACCT_TRANSFER_PRICE
,      PROJ_CURRENCY_CODE
,      CROSS_CHARGE_CODE
,      EXPENDITURE_TYPE
,      REVENUE_DISTRIBUTED_FLAG
,      JOB_ID
,      EXPENDITURE_GROUP
,      EXPENDITURE_ENDING_DATE
,      PA_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      TASK_ORGANIZATION_ID
,      TASK_NUMBER
,      REVENUE_CATEGORY
,      EXPENDITURE_CATEGORY
,      NON_LABOR_RESOURCE
,      PROJ_ORGANIZATION_ID
,      PROJ_ORGANIZATION_NAME
,      TASK_ORGANIZATION_NAME
,      TASK_SERVICE_TYPE
,      PROJECT_TYPE
,      PROJECT_NUMBER
,      PRVDR_ORGANIZATION_NAME
,      RECVR_ORGANIZATION_NAME
,      RECVR_ORG_ID
,      RECVR_ORG_NAME
,      EMPLOYEE_NUMBER
,      PERSON_ID
,      TP_SCHEDULE_ID
,      TP_FIXED_DATE
,      TP_IND_COMPILED_SET_ID
,      TP_BILL_RATE
,      TP_BILL_MARKUP_PERCENTAGE
,      TP_SCHEDULE_LINE_PERCENTAGE
,      TP_RULE_PERCENTAGE
,      MARKUP_CALC_BASE_CODE
,      TP_BASE_AMOUNT
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      RAW_REVENUE
,      LABOR_NON_LABOR_FLAG
,      FN_TRN_CODE_BORR
,      FN_TRN_NUM_BORR
,      FN_TRN_CODE_LENT
,      FN_TRN_NUM_LENT
,      ORG_ID
FROM APPS.PA_CC_BL_CUR_SEL_V;

Dependencies

[top of page]

APPS.PA_CC_BL_CUR_SEL_V references the following:

APPS: FND_LANGUAGES; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_EMPLOYEES; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_EXPENDITURE_TYPES; PA_FUNCTION_TRANSACTIONS; PA_PROJECTS_ALL; PA_SYSTEM_LINKAGES; PA_TASKS; PA_UTILS - show dependent code

APPS.PA_CC_BL_CUR_SEL_V is not referenced by any database object