[Home] [Help]
[Dependency Information]
| Object Name: | PA_TASKS_EXPEND_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PA.PA_TASKS_EXPEND_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | (15) | ||
| PROJECT_NUMBER | VARCHAR2 | (25) | ||
| TASK_ID | NUMBER | (15) | The task ID for projects for which cost breakdown planning is disabled or the alternate task ID for projects which have cost breakdown planning enabled | |
| TASK_NUMBER | VARCHAR2 | (278) | The task number for projects for which cost breakdown planning is disabled or the alternate task number for projects which have cost breakdown planning enabled | |
| TASK_NAME | VARCHAR2 | (263) | The task name for projects for which cost breakdown planning is disabled or the alternate task name for projects which have cost breakdown planning enabled | |
| INDENTED_TASK_NAME | VARCHAR2 | (4000) | Alternate Task Name instaed of task name for the CBS enabled projects | |
| START_DATE | DATE | |||
| LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | (20) | ||
| COMPLETION_DATE | DATE | |||
| CHARGEABLE_FLAG | VARCHAR2 | (1) | ||
| WBS_SORT_ORDER | VARCHAR2 | (2000) | ||
| ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Flag to indicate whether cross charge are allowed | |
| PROJECT_RATE_DATE | DATE | Task level default value for project rate date | ||
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | Task level default value for project rate type | |
| BILLABLE_FLAG | VARCHAR2 | (1) | ||
| TASK_ORGANIZATION | NUMBER | (15) | ||
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | Task level default value for project functional rate type | |
| PROJFUNC_COST_RATE_DATE | DATE | Task level default value for project functional rate date | ||
| WORK_TYPE_ID | NUMBER | (15) | ||
| WORK_TYPE_NAME | VARCHAR2 | (200) | ||
| TP_AMT_TYPE_CODE | VARCHAR2 | (200) | ||
| TASK_DESCRIPTION | VARCHAR2 | (250) | ||
| ORG_ID | NUMBER | (15) | ||
| CBS_ELEMENT_ID | NUMBER | The unique identifier of the cost breakdown structure element | ||
| COST_CODE | VARCHAR2 | (250) | The unique cost code generated for the cost attribute | |
| COST_CODE_NAME | VARCHAR2 | (240) | The cost code name | |
| ACTUAL_TASK_ID | NUMBER | (15) | The system generated unique task identifier | |
| TOP_TASK_ID | NUMBER | (15) | The identifier of the top task. If this is a top task, this value is the task ID | |
| TASK_MANAGER_PERSON_ID | NUMBER | (9) | The identifier of the employee who manages the task |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, INDENTED_TASK_NAME
, START_DATE
, LABOR_COST_MULTIPLIER_NAME
, COMPLETION_DATE
, CHARGEABLE_FLAG
, WBS_SORT_ORDER
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, BILLABLE_FLAG
, TASK_ORGANIZATION
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, WORK_TYPE_ID
, WORK_TYPE_NAME
, TP_AMT_TYPE_CODE
, TASK_DESCRIPTION
, ORG_ID
, CBS_ELEMENT_ID
, COST_CODE
, COST_CODE_NAME
, ACTUAL_TASK_ID
, TOP_TASK_ID
, TASK_MANAGER_PERSON_ID
FROM APPS.PA_TASKS_EXPEND_V;
APPS
FND_PROFILE
- show dependent code
PA_ALTERNATE_TASKS
PA_IMPLEMENTATIONS
PA_LOOKUPS
PA_PROJECTS_ALL
PA_RBS_ELEMENTS
PA_TASKS
PA_TASK_UTILS
- show dependent code
PA_UTILS4
- show dependent code
APPS
AP_INVOICES_V
AP_INVOICE_DISTRIBUTIONS_V
AP_INVOICE_DISTS_INQUIRY_V
AP_INVOICE_LINES_INTERFACE_V
AP_INVOICE_LINES_V
AP_MATCH_CORRECTION_DISTS_V
AP_PO_DISTRIBUTIONS_AP2_V
AP_WEB_DB_EXPLINE_PKG
- show dependent code
AP_WEB_DB_PA_INT_PKG
- show dependent code
AP_WEB_DB_PA_INT_PKG
- show dependent code
AP_WEB_DFLEX_PKG
- show dependent code
AP_WEB_DISC_PKG
- show dependent code
AP_WEB_EXPENSE_WF
- show dependent code
AP_WEB_PARENT_PKG
- show dependent code
AP_WEB_PA_PROJECTS_TASKS_V
AP_WEB_PROJECT_PKG
- show dependent code
AP_WEB_PROJECT_PKG
- show dependent code
CS_CHARGE_DETAILS_PVT
- show dependent code
CS_SERVICEREQUEST_UTIL
- show dependent code
HXC_RDB_POST_RETRIEVAL
- show dependent code
HXC_RDB_PRE_RETRIEVAL
- show dependent code
HXT_RETRO_PA
- show dependent code
HXT_SUM_HOURS_WORKED_FMV
HXT_TRAN_PA
- show dependent code
INV_INVTOPKL_XMLP_PKG
- show dependent code
OKE_ACTION_VALIDATIONS_PKG
- show dependent code
OKE_DTS_INTEGRATION_PKG
- show dependent code
PA_EXPENDITURE_HISTORY_V
PA_PROJECT_TASKS_AP_V
PA_PROJ_AP_INV_DISTRIBUTIONS
PA_PROJ_PO_DISTRIBUTIONS
PA_PROJ_REQ_DISTRIBUTIONS
PA_TASKS_AP_V
PNP_UTIL_FUNC
- show dependent code
PN_LEASE_PVT
- show dependent code
PON_CP_INTRFAC_TO_TRANSACTION
- show dependent code
PON_NEGOTIATION_PUBLISH_PVT
- show dependent code
PON_PRINTING_PKG
- show dependent code
PON_VALIDATE_ITEM_PRICES_INT
- show dependent code
PON_VALIDATE_PAYMENTS_INT
- show dependent code
POR_AMENDMENT_PKG
- show dependent code
POR_TASK_LOV_V
POR_VIEW_LINE_DETAILS_V
POR_VIEW_REQS_PKG
- show dependent code
POR_WIP_ENTITY_NAME_LOV_V
POS_WCAPPROVE_PVT
- show dependent code
PO_COPYDOC_SUB
- show dependent code
PO_DISTRIBUTIONS_SV
- show dependent code
PO_PDOI_DISTRIBUTIONS_SV3
- show dependent code
PO_PDOI_DIST_PROCESS_PVT
- show dependent code
PO_PROJECT_DETAILS_SV
- show dependent code
PO_REQ_DISTRIBUTIONS_INQ_V
PO_REQ_WF_BUILD_ACCOUNT_INIT
- show dependent code
PO_STORE_TIMECARD_PKG_GRP
- show dependent code
PO_WF_BUILD_ACCOUNT_INIT
- show dependent code
PQH_UTILITY
- show dependent code
PSP_CREATE_EFF_REPORTS
- show dependent code
PSP_DEFAULT_LABOR_SCHEDULES_V
PSP_ELEMENT_TYPE_ACCOUNTS_V
PSP_ENC_CREATE_LINES
- show dependent code
PSP_ENC_CRT_XML
- show dependent code
PSP_ENC_LIQ_TRAN
- show dependent code
PSP_ENC_SUM_TRAN
- show dependent code
PSP_GENERAL
- show dependent code
PSP_LABOR_DIST
- show dependent code
PSP_MATRIX_DRIVER2_V
PSP_MATRIX_DRIVER3_V
PSP_MATRIX_DRIVER_V
PSP_ORGANIZATION_ACCOUNTS_V
PSP_PAYTRN
- show dependent code
PSP_POA_BUS
- show dependent code
PSP_PSPDAREG_XMLP_PKG
- show dependent code
PSP_PSPENAWD_XMLP_PKG
- show dependent code
PSP_PSPENCDU_XMLP_PKG
- show dependent code
PSP_PSPENCSC_XMLP_PKG
- show dependent code
PSP_PSPENORG_XMLP_PKG
- show dependent code
PSP_PSPLDAWD_XMLP_PKG
- show dependent code
PSP_PSPLDDFA_XMLP_PKG
- show dependent code
PSP_PSPLDPRJ_XMLP_PKG
- show dependent code
PSP_PSPLDSSA_XMLP_PKG
- show dependent code
PSP_PSPLSEMP_XMLP_PKG
- show dependent code
PSP_PSPLSODL_XMLP_PKG
- show dependent code
PSP_PSPLSODR_XMLP_PKG
- show dependent code
PSP_PSPRCDLS_XMLP_PKG
- show dependent code
PSP_PSPRCPGD_XMLP_PKG
- show dependent code
PSP_PSPRCSLD_XMLP_PKG
- show dependent code
PSP_SUM_ADJ
- show dependent code
PSP_SUM_TRANS
- show dependent code
PSP_XMLGEN
- show dependent code
RCV_RECEIPTS_QUERY_SV
- show dependent code
RCV_TRANSACTION_SV
- show dependent code
WIP_FLOW_VALIDATION
- show dependent code
WIP_JSI_DEFAULTER
- show dependent code
WIP_VALIDATE
- show dependent code
WIP_VALIDATEMLHEADER_PVT
- show dependent code
|
|
|
|