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_TRX_FUNDS_CHK_DET_V

Object Details

Object Name:	PA_TRX_FUNDS_CHK_DET_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_TRX_FUNDS_CHK_DET_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
PACKET_ID	NUMBER	(15)	Yes
BC_PACKET_ID	NUMBER	(15)	Yes
PARENT_BC_PACKET_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROJECT_ID	NUMBER	(15)	Yes
TASK_ID	NUMBER	(15)	Yes
TOP_TASK_ID	NUMBER	(15)
BUDGET_CCID	NUMBER	(15)
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
EXPENDITURE_ITEM_DATE	DATE		Yes
ACTUAL_FLAG	VARCHAR2	(1)	Yes
STATUS_CODE	VARCHAR2	(1)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
JE_CATEGORY_NAME	VARCHAR2	(30)	Yes
JE_SOURCE_NAME	VARCHAR2	(30)	Yes
DOCUMENT_TYPE	VARCHAR2	(10)	Yes
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)	Yes
PERIOD_NAME	VARCHAR2	(15)
PERIOD_YEAR	NUMBER
PERIOD_NUM	NUMBER
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)	Yes
BUDGET_VERSION_ID	NUMBER	(15)	Yes
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
EFFECT_ON_FUNDS_CODE	VARCHAR2	(1)
RESULT_CODE	VARCHAR2	(5)
GL_ROW_NUMBER	VARCHAR2	(30)
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
PARENT_RESOURCE_ID	NUMBER	(15)
BUD_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)
BUD_TASK_ID	NUMBER	(15)
R_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)
RG_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)
T_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)
TT_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)
P_FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(1)
PROJECT_BUDGET_POSTED	NUMBER
TOTAL_PROJECT_BUDGET	NUMBER
PROJECT_ENC_POSTED	NUMBER
PROJECT_ENC_APPROVED	NUMBER
TOTAL_PROJECT_ENCUMBRANCE	NUMBER
PROJECT_ACTUAL_POSTED	NUMBER
PROJECT_ACTUAL_APPROVED	NUMBER
TOTAL_PROJECT_ACTUAL	NUMBER
PROJECT_RESULT_CODE	VARCHAR2	(5)
TOP_TASK_BUDGET_POSTED	NUMBER
TOTAL_TOP_TASK_BUDGET	NUMBER
TOP_TASK_ENC_POSTED	NUMBER
TOP_TASK_ENC_APPROVED	NUMBER
TOTAL_TOP_TASK_ENCUMBRANCE	NUMBER
TOP_TASK_ACTUAL_POSTED	NUMBER
TOP_TASK_ACTUAL_APPROVED	NUMBER
TOTAL_TOP_TASK_ACTUAL	NUMBER
TOP_TASK_RESULT_CODE	VARCHAR2	(5)
TASK_BUDGET_POSTED	NUMBER
TOTAL_TASK_BUDGET	NUMBER
TASK_ENC_POSTED	NUMBER
TASK_ENC_APPROVED	NUMBER
TOTAL_TASK_ENCUMBRANCE	NUMBER
TASK_ACTUAL_POSTED	NUMBER
TASK_ACTUAL_APPROVED	NUMBER
TOTAL_TASK_ACTUAL	NUMBER
TASK_RESULT_CODE	VARCHAR2	(5)
RES_GRP_BUDGET_POSTED	NUMBER
TOTAL_RES_GRP_BUDGET	NUMBER
RES_GRP_ENC_POSTED	NUMBER
RES_GRP_ENC_APPROVED	NUMBER
TOTAL_RES_GRP_ENC	NUMBER
RES_GRP_ACTUAL_POSTED	NUMBER
RES_GRP_ACTUAL_APPROVED	NUMBER
TOTAL_RES_GRP_ACTUAL	NUMBER
RES_GRP_RESULT_CODE	VARCHAR2	(5)
RES_BUDGET_POSTED	NUMBER
TOTAL_RES_BUDGET	NUMBER
RES_ENC_POSTED	NUMBER
RES_ENC_APPROVED	NUMBER
TOTAL_RES_ENC	NUMBER
RES_ACTUAL_POSTED	NUMBER
RES_ACTUAL_APPROVED	NUMBER
TOTAL_RES_ACTUAL	NUMBER
RES_RESULT_CODE	VARCHAR2	(5)
PROJECT_FA_POSTED	NUMBER
TOP_TASK_FA_POSTED	NUMBER
TASK_FA_POSTED	NUMBER
RES_FA_POSTED	NUMBER
RES_GRP_FA_POSTED	NUMBER
TOTAL_PROJECT_FA	NUMBER
TOTAL_TASK_FA	NUMBER
TOTAL_TOP_TASK_FA	NUMBER
TOTAL_RES_FA	NUMBER
TOTAL_RES_GRP_FA	NUMBER
PROJECT	VARCHAR2	(25)	Yes
TASK	VARCHAR2	(25)	Yes
VERSION_NAME	VARCHAR2	(60)
PA_RESULT_CODE_MEAN	VARCHAR2	(80)
PROJECT_RESULT_CODE_MEAN	VARCHAR2	(80)
TASK_RESULT_CODE_MEAN	VARCHAR2	(80)
RES_RESULT_CODE_MEAN	VARCHAR2	(80)
RES_GRP_RESULT_CODE_MEAN	VARCHAR2	(80)
TOP_TASK_RESULT_CODE_MEAN	VARCHAR2	(80)

Query Text

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


SELECT ROW_ID
,      PACKET_ID
,      BC_PACKET_ID
,      PARENT_BC_PACKET_ID
,      REQUEST_ID
,      PROJECT_ID
,      TASK_ID
,      TOP_TASK_ID
,      BUDGET_CCID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      ACTUAL_FLAG
,      STATUS_CODE
,      SET_OF_BOOKS_ID
,      JE_CATEGORY_NAME
,      JE_SOURCE_NAME
,      DOCUMENT_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      BUDGET_VERSION_ID
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      GL_ROW_NUMBER
,      RESOURCE_LIST_MEMBER_ID
,      PARENT_RESOURCE_ID
,      BUD_RESOURCE_LIST_MEMBER_ID
,      BUD_TASK_ID
,      R_FUNDS_CONTROL_LEVEL_CODE
,      RG_FUNDS_CONTROL_LEVEL_CODE
,      T_FUNDS_CONTROL_LEVEL_CODE
,      TT_FUNDS_CONTROL_LEVEL_CODE
,      P_FUNDS_CONTROL_LEVEL_CODE
,      PROJECT_BUDGET_POSTED
,      TOTAL_PROJECT_BUDGET
,      PROJECT_ENC_POSTED
,      PROJECT_ENC_APPROVED
,      TOTAL_PROJECT_ENCUMBRANCE
,      PROJECT_ACTUAL_POSTED
,      PROJECT_ACTUAL_APPROVED
,      TOTAL_PROJECT_ACTUAL
,      PROJECT_RESULT_CODE
,      TOP_TASK_BUDGET_POSTED
,      TOTAL_TOP_TASK_BUDGET
,      TOP_TASK_ENC_POSTED
,      TOP_TASK_ENC_APPROVED
,      TOTAL_TOP_TASK_ENCUMBRANCE
,      TOP_TASK_ACTUAL_POSTED
,      TOP_TASK_ACTUAL_APPROVED
,      TOTAL_TOP_TASK_ACTUAL
,      TOP_TASK_RESULT_CODE
,      TASK_BUDGET_POSTED
,      TOTAL_TASK_BUDGET
,      TASK_ENC_POSTED
,      TASK_ENC_APPROVED
,      TOTAL_TASK_ENCUMBRANCE
,      TASK_ACTUAL_POSTED
,      TASK_ACTUAL_APPROVED
,      TOTAL_TASK_ACTUAL
,      TASK_RESULT_CODE
,      RES_GRP_BUDGET_POSTED
,      TOTAL_RES_GRP_BUDGET
,      RES_GRP_ENC_POSTED
,      RES_GRP_ENC_APPROVED
,      TOTAL_RES_GRP_ENC
,      RES_GRP_ACTUAL_POSTED
,      RES_GRP_ACTUAL_APPROVED
,      TOTAL_RES_GRP_ACTUAL
,      RES_GRP_RESULT_CODE
,      RES_BUDGET_POSTED
,      TOTAL_RES_BUDGET
,      RES_ENC_POSTED
,      RES_ENC_APPROVED
,      TOTAL_RES_ENC
,      RES_ACTUAL_POSTED
,      RES_ACTUAL_APPROVED
,      TOTAL_RES_ACTUAL
,      RES_RESULT_CODE
,      PROJECT_FA_POSTED
,      TOP_TASK_FA_POSTED
,      TASK_FA_POSTED
,      RES_FA_POSTED
,      RES_GRP_FA_POSTED
,      TOTAL_PROJECT_FA
,      TOTAL_TASK_FA
,      TOTAL_TOP_TASK_FA
,      TOTAL_RES_FA
,      TOTAL_RES_GRP_FA
,      PROJECT
,      TASK
,      VERSION_NAME
,      PA_RESULT_CODE_MEAN
,      PROJECT_RESULT_CODE_MEAN
,      TASK_RESULT_CODE_MEAN
,      RES_RESULT_CODE_MEAN
,      RES_GRP_RESULT_CODE_MEAN
,      TOP_TASK_RESULT_CODE_MEAN
FROM APPS.PA_TRX_FUNDS_CHK_DET_V;

Dependencies

[top of page]

APPS.PA_TRX_FUNDS_CHK_DET_V references the following:

APPS: PA_BC_PACKETS; PA_BUDGET_VERSIONS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_TASKS

APPS.PA_TRX_FUNDS_CHK_DET_V is not referenced by any database object