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_FP_BUDGET_LINE_REJECTIONS_V

Object Details

Object Name:	PA_FP_BUDGET_LINE_REJECTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_FP_BUDGET_LINE_REJECTIONS_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	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The identifier of the budget version.
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project.
TASK_ID	NUMBER	(15)	Yes	The identifier of the task.
BUDGET_LINE_ID	NUMBER	(15)	Yes	The identifier of the budget line.
START_DATE	DATE		Yes	The start date of the budget line.
END_DATE	DATE		Yes	The end date of the budget line.
PERIOD_NAME	VARCHAR2	(30)		The period of the budget line.
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)	Yes	The identifier of the resource assignment of the budget line.
TXN_CURRENCY_CODE	VARCHAR2	(15)	Yes	The transaction currency code of the amount.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		The project currency code.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		The project functional currency code.
COST_REJECTION_CODE	VARCHAR2	(30)		It stores the message code that is applicable whenever an error is encountered during calculation of cost amounts.
COST_REJECTION_MSG_DATA	VARCHAR2	(2000)		The message text of the cost_rejection_code.
COST_REJECTION_FLAG	VARCHAR2	(1)		This flag indcates if the budget line contains rejection code during calculation of cost amounts.
PERIOD_COST_REJECTION_FLAG	VARCHAR2	(1)		This flag indcates if a period of the budget line contains rejection code during calculation of cost amounts.
BURDEN_REJECTION_CODE	VARCHAR2	(30)		It stores the message code that is applicable whenever an error is encountered during calculation of burdened cost amounts.
BURDEN_REJECTION_MSG_DATA	VARCHAR2	(2000)		The message text of the burden_rejection_code.
BURDEN_REJECTION_FLAG	VARCHAR2	(1)		This flag indcates if the budget line contains rejection code during calculation of burdened cost amounts.
PERIOD_BURDEN_REJECTION_FLAG	VARCHAR2	(1)		This flag indcates if a period of the budget line contains rejection code during calculation of burdened cost amounts.
REVENUE_REJECTION_CODE	VARCHAR2	(30)		It stores the message code that is applicable whenever an error is encountered during calculation of revenue amounts.
REVENUE_REJECTION_MSG_DATA	VARCHAR2	(2000)		The message text of the revenue_rejection_code.
REVENUE_REJECTION_FLAG	VARCHAR2	(1)		This flag indcates if the budget line contains rejection code during calculation of revenue amounts.
PERIOD_REVENUE_REJECTION_FLAG	VARCHAR2	(1)		This flag indcates if a period of the budget line contains rejection code during calculation of revenue amounts.
PC_CUR_CONV_REJECTION_CODE	VARCHAR2	(30)		Indicates the rejection code while trying to convert the transaction currency into project currency.
PC_CONV_REJECTION_MSG_DATA	VARCHAR2	(2000)		The message text of the pc_cur_conv_rejection_code.
PC_CONV_REJECTION_FLAG	VARCHAR2	(1)		This flag indicates if the budget line contains rejection code while trying to convert the transaction currency into project currency.
PERIOD_PC_CONV_REJECTION_FLAG	VARCHAR2	(1)		This flag indicates if a period of the budget line contains rejection code while trying to convert the transaction currency into project currency.
PFC_CUR_CONV_REJECTION_CODE	VARCHAR2	(30)		Indicates the rejection code while trying to convert the transaction currency into project functional currency.
PFC_CONV_REJECTION_MSG_DATA	VARCHAR2	(2000)		The message text of the pfc_cur_conv_rejection_code.
PFC_CONV_REJECTION_FLAG	VARCHAR2	(1)		This flag indicates if the budget line contains rejection code while trying to convert the transaction currency into project functional currency.
PERIOD_PFC_CONV_REJECTION_FLAG	VARCHAR2	(1)		This flag indicates if a period of the budget line contains rejection code while trying to convert the transaction currency into project functional currency.
OTHER_REJECTION_CODE	VARCHAR2	(30)		It stores the message code that is applicable whenever an unexpected error is encountered.
OTHER_REJECTION_MSG_DATA	VARCHAR2	(2000)		The message text of the other_rejection_code.
OTHER_REJECTION_FLAG	VARCHAR2	(1)		This flag indicates if the budget line contains any rejection code due to unexpected error.
PERIOD_OTHER_REJECTION_FLAG	VARCHAR2	(1)		This flag indicates if a period of the budget line contains any rejection code due to unexpected error.
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes	The identifier of the resource list member within the resource list that is assigned to the budget.
RESOURCE_LIST_MEMBER_NAME	VARCHAR2	(80)		User defined short name for the resource.
RESOURCE_LIST_ID	NUMBER	(15)	Yes	The identifier of the resource list.

Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      BUDGET_LINE_ID
,      START_DATE
,      END_DATE
,      PERIOD_NAME
,      RESOURCE_ASSIGNMENT_ID
,      TXN_CURRENCY_CODE
,      PROJECT_CURRENCY_CODE
,      PROJFUNC_CURRENCY_CODE
,      COST_REJECTION_CODE
,      COST_REJECTION_MSG_DATA
,      COST_REJECTION_FLAG
,      PERIOD_COST_REJECTION_FLAG
,      BURDEN_REJECTION_CODE
,      BURDEN_REJECTION_MSG_DATA
,      BURDEN_REJECTION_FLAG
,      PERIOD_BURDEN_REJECTION_FLAG
,      REVENUE_REJECTION_CODE
,      REVENUE_REJECTION_MSG_DATA
,      REVENUE_REJECTION_FLAG
,      PERIOD_REVENUE_REJECTION_FLAG
,      PC_CUR_CONV_REJECTION_CODE
,      PC_CONV_REJECTION_MSG_DATA
,      PC_CONV_REJECTION_FLAG
,      PERIOD_PC_CONV_REJECTION_FLAG
,      PFC_CUR_CONV_REJECTION_CODE
,      PFC_CONV_REJECTION_MSG_DATA
,      PFC_CONV_REJECTION_FLAG
,      PERIOD_PFC_CONV_REJECTION_FLAG
,      OTHER_REJECTION_CODE
,      OTHER_REJECTION_MSG_DATA
,      OTHER_REJECTION_FLAG
,      PERIOD_OTHER_REJECTION_FLAG
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_MEMBER_NAME
,      RESOURCE_LIST_ID
FROM APPS.PA_FP_BUDGET_LINE_REJECTIONS_V;

Dependencies

[top of page]

APPS.PA_FP_BUDGET_LINE_REJECTIONS_V references the following:

APPS: FND_NEW_MESSAGES; PA_BUDGET_LINES; PA_BUDGET_VERSIONS; PA_FIN_PLAN_UTILS2 - show dependent code; PA_RESOURCE_ASSIGNMENTS; PA_RESOURCE_LIST_MEMBERS
PUBLIC: DUAL

APPS.PA_FP_BUDGET_LINE_REJECTIONS_V is referenced by following:

APPS: PA_FIN_PLAN_UTILS2 - show dependent code