[Home] [Help]
[Dependency Information]
| 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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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) | ||
| PA_RESULT_CODE_CORR | VARCHAR2 | (4000) | ||
| PROJECT_RESULT_CODE_CORR | VARCHAR2 | (4000) | ||
| TASK_RESULT_CODE_CORR | VARCHAR2 | (4000) | ||
| RES_RESULT_CODE_CORR | VARCHAR2 | (4000) | ||
| RES_GRP_RESULT_CODE_CORR | VARCHAR2 | (4000) | ||
| TOP_TASK_RESULT_CODE_CORR | VARCHAR2 | (4000) | ||
| AMOUNT_TYPE | VARCHAR2 | (15) | ||
| BOUNDARY_CODE | VARCHAR2 | (7) | ||
| TIME_PHASED_TYPE_CODE | VARCHAR2 | (10) | ||
| FC_START_DATE | DATE | |||
| FC_END_DATE | DATE | |||
| BUDGET_ENTRY_METHOD | VARCHAR2 | (30) | Yes |
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
, PA_RESULT_CODE_CORR
, PROJECT_RESULT_CODE_CORR
, TASK_RESULT_CODE_CORR
, RES_RESULT_CODE_CORR
, RES_GRP_RESULT_CODE_CORR
, TOP_TASK_RESULT_CODE_CORR
, AMOUNT_TYPE
, BOUNDARY_CODE
, TIME_PHASED_TYPE_CODE
, FC_START_DATE
, FC_END_DATE
, BUDGET_ENTRY_METHOD
FROM APPS.PA_TRX_FUNDS_CHK_DET_V;
APPS
MO_GLOBAL
- show dependent code
PA_BC_PACKETS
PA_BUDGETARY_CONTROL_OPTIONS
PA_BUDGET_ENTRY_METHODS
PA_BUDGET_VERSIONS
PA_FUNDS_CONTROL_UTILS
- show dependent code
PA_LOOKUPS
PA_OPERATING_UNITS_V
PA_PROJECTS_ALL
PA_TASKS
APPS.PA_TRX_FUNDS_CHK_DET_V is not referenced by any database object
|
|
|
|