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)
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
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
,      CBS_ELEMENT_ID
,      COST_CODE
,      COST_CODE_NAME
,      ACTUAL_TASK_ID
,      TOP_TASK_ID
,      TASK_MANAGER_PERSON_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_ALTERNATE_TASKS
SynonymPA_IMPLEMENTATIONS
ViewPA_LOOKUPS
SynonymPA_PROJECTS_ALL
SynonymPA_RBS_ELEMENTS
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
ViewAP_INVOICES_V
ViewAP_INVOICE_DISTRIBUTIONS_V
ViewAP_INVOICE_DISTS_INQUIRY_V
ViewAP_INVOICE_LINES_INTERFACE_V
ViewAP_INVOICE_LINES_V
ViewAP_MATCH_CORRECTION_DISTS_V
ViewAP_PO_DISTRIBUTIONS_AP2_V
Package BodyAP_WEB_DB_EXPLINE_PKG - show dependent code
PL/SQL PackageAP_WEB_DB_PA_INT_PKG - show dependent code
Package BodyAP_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
PL/SQL PackageAP_WEB_PROJECT_PKG - show dependent code
Package BodyAP_WEB_PROJECT_PKG - show dependent code
Package BodyCS_CHARGE_DETAILS_PVT - show dependent code
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
Package BodyHXC_RDB_POST_RETRIEVAL - show dependent code
Package BodyHXC_RDB_PRE_RETRIEVAL - show dependent code
Package BodyHXT_RETRO_PA - show dependent code
ViewHXT_SUM_HOURS_WORKED_FMV
Package BodyHXT_TRAN_PA - 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
ViewPA_PROJECT_TASKS_AP_V
ViewPA_PROJ_AP_INV_DISTRIBUTIONS
ViewPA_PROJ_PO_DISTRIBUTIONS
ViewPA_PROJ_REQ_DISTRIBUTIONS
ViewPA_TASKS_AP_V
Package BodyPNP_UTIL_FUNC - show dependent code
Package BodyPN_LEASE_PVT - show dependent code
Package BodyPON_CP_INTRFAC_TO_TRANSACTION - show dependent code
Package BodyPON_NEGOTIATION_PUBLISH_PVT - show dependent code
Package BodyPON_PRINTING_PKG - show dependent code
Package BodyPON_VALIDATE_ITEM_PRICES_INT - show dependent code
Package BodyPON_VALIDATE_PAYMENTS_INT - show dependent code
Package BodyPOR_AMENDMENT_PKG - show dependent code
ViewPOR_TASK_LOV_V
ViewPOR_VIEW_LINE_DETAILS_V
Package BodyPOR_VIEW_REQS_PKG - show dependent code
ViewPOR_WIP_ENTITY_NAME_LOV_V
Package BodyPOS_WCAPPROVE_PVT - show dependent code
Package BodyPO_COPYDOC_SUB - show dependent code
Package BodyPO_DISTRIBUTIONS_SV - show dependent code
Package BodyPO_PDOI_DISTRIBUTIONS_SV3 - show dependent code
Package BodyPO_PDOI_DIST_PROCESS_PVT - show dependent code
Package BodyPO_PROJECT_DETAILS_SV - show dependent code
ViewPO_REQ_DISTRIBUTIONS_INQ_V
Package BodyPO_REQ_WF_BUILD_ACCOUNT_INIT - show dependent code
Package BodyPO_STORE_TIMECARD_PKG_GRP - show dependent code
Package BodyPO_WF_BUILD_ACCOUNT_INIT - show dependent code
Package BodyPQH_UTILITY - show dependent code
Package BodyPSP_CREATE_EFF_REPORTS - show dependent code
ViewPSP_DEFAULT_LABOR_SCHEDULES_V
ViewPSP_ELEMENT_TYPE_ACCOUNTS_V
Package BodyPSP_ENC_CREATE_LINES - show dependent code
Package BodyPSP_ENC_CRT_XML - show dependent code
Package BodyPSP_ENC_LIQ_TRAN - show dependent code
Package BodyPSP_ENC_SUM_TRAN - show dependent code
Package BodyPSP_GENERAL - show dependent code
Package BodyPSP_LABOR_DIST - show dependent code
ViewPSP_MATRIX_DRIVER2_V
ViewPSP_MATRIX_DRIVER3_V
ViewPSP_MATRIX_DRIVER_V
ViewPSP_ORGANIZATION_ACCOUNTS_V
Package BodyPSP_PAYTRN - show dependent code
Package BodyPSP_POA_BUS - show dependent code
Package BodyPSP_PSPDAREG_XMLP_PKG - show dependent code
Package BodyPSP_PSPENAWD_XMLP_PKG - show dependent code
Package BodyPSP_PSPENCDU_XMLP_PKG - show dependent code
Package BodyPSP_PSPENCSC_XMLP_PKG - show dependent code
Package BodyPSP_PSPENORG_XMLP_PKG - show dependent code
Package BodyPSP_PSPLDAWD_XMLP_PKG - show dependent code
Package BodyPSP_PSPLDDFA_XMLP_PKG - show dependent code
Package BodyPSP_PSPLDPRJ_XMLP_PKG - show dependent code
Package BodyPSP_PSPLDSSA_XMLP_PKG - show dependent code
Package BodyPSP_PSPLSEMP_XMLP_PKG - show dependent code
Package BodyPSP_PSPLSODL_XMLP_PKG - show dependent code
Package BodyPSP_PSPLSODR_XMLP_PKG - show dependent code
Package BodyPSP_PSPRCDLS_XMLP_PKG - show dependent code
Package BodyPSP_PSPRCPGD_XMLP_PKG - show dependent code
Package BodyPSP_PSPRCSLD_XMLP_PKG - show dependent code
Package BodyPSP_SUM_ADJ - show dependent code
Package BodyPSP_SUM_TRANS - show dependent code
Package BodyPSP_XMLGEN - 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