[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.PA_TRX_FUNDS_CHK_DET_V is not referenced by any database object
|
|
|