DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PA_TASKS_EXPEND_V

Object Details
Object Name: PA_TASKS_EXPEND_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_TASKS_EXPEND_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
PROJECT_ID NUMBER (15) Yes
PROJECT_NUMBER VARCHAR2 (25) Yes
TASK_ID NUMBER (15) Yes
TASK_NUMBER VARCHAR2 (25) Yes
TASK_NAME VARCHAR2 (20) Yes
INDENTED_TASK_NAME VARCHAR2 (4000)
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) Yes 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) Yes
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)
Query Text

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
FROM APPS.PA_TASKS_EXPEND_V;

Dependencies

[top of page]

APPS.PA_TASKS_EXPEND_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymPA_IMPLEMENTATIONS
ViewPA_LOOKUPS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
PL/SQL PackagePA_TASK_UTILS - show dependent code
PL/SQL PackagePA_UTILS4 - show dependent code
APPS.PA_TASKS_EXPEND_V is referenced by following:

SchemaAPPS
Package BodyAP_WEB_DB_PA_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_DB_PA_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_DFLEX_PKG - show dependent code
Package BodyAP_WEB_DISC_PKG - show dependent code
Package BodyAP_WEB_EXPENSE_WF - show dependent code
Package BodyAP_WEB_PARENT_PKG - show dependent code
ViewAP_WEB_PA_PROJECTS_TASKS_V
Package BodyAP_WEB_PROJECT_PKG - show dependent code
PL/SQL PackageAP_WEB_PROJECT_PKG - show dependent code
Package BodyINV_INVTOPKL_XMLP_PKG - show dependent code
Package BodyOKE_ACTION_VALIDATIONS_PKG - show dependent code
Package BodyOKE_DTS_INTEGRATION_PKG - show dependent code
ViewPA_EXPENDITURE_HISTORY_V
Package BodyPNP_UTIL_FUNC - show dependent code
Package BodyPON_CP_INTRFAC_TO_TRANSACTION - show dependent code
Package BodyPON_NEGOTIATION_PUBLISH_PVT - show dependent code
Package BodyPON_VALIDATE_ITEM_PRICES_INT - show dependent code
Package BodyPON_VALIDATE_PAYMENTS_INT - show dependent code
ViewPOR_TASK_LOV_V
ViewPOR_WIP_ENTITY_NAME_LOV_V
Package BodyPO_COPYDOC_SUB - show dependent code
Package BodyPO_PDOI_DISTRIBUTIONS_SV3 - show dependent code
Package BodyPO_PDOI_DIST_PROCESS_PVT - show dependent code
Package BodyPQH_UTILITY - show dependent code
Package BodyPSP_POA_BUS - show dependent code
Package BodyPSP_PSPENCDU_XMLP_PKG - show dependent code
Package BodyPSP_PSPENCSC_XMLP_PKG - show dependent code
Package BodyPSP_PSPLSODL_XMLP_PKG - show dependent code
Package BodyRCV_RECEIPTS_QUERY_SV - show dependent code
Package BodyRCV_TRANSACTION_SV - show dependent code
Package BodyWIP_FLOW_VALIDATION - show dependent code
Package BodyWIP_JSI_DEFAULTER - show dependent code
Package BodyWIP_VALIDATE - show dependent code
Package BodyWIP_VALIDATEMLHEADER_PVT - show dependent code