[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJECTS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_PROJECTS_ALL
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_PROJECTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PROJECT_ID
|
| PA_PROJECTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SEGMENT1
|
| PA_PROJECTS_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| PA_PROJECTS_U4 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PM_PROJECT_REFERENCE
PM_PRODUCT_CODE
|
| PA_PROJECTS_U5 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
LONG_NAME
|
| PA_PROJECTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LABOR_BILL_RATE_ORG_ID
LABOR_STD_BILL_RATE_SCHDL
|
| PA_PROJECTS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NON_LAB_STD_BILL_RT_SCH_ID
|
| PA_PROJECTS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_TYPE
|
| PA_PROJECTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARRYING_OUT_ORGANIZATION_ID
PROJECT_STATUS_CODE
COMPLETION_DATE
START_DATE
|
| PA_PROJECTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NON_LABOR_BILL_RATE_ORG_ID
NON_LABOR_STD_BILL_RATE_SCHDL
|
| PA_PROJECTS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_STATUS_CODE
|
| PA_PROJECTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADW_NOTIFY_FLAG
|
| PA_PROJECTS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TEMPLATE_FLAG
|
| PA_PROJECTS_N7 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPPER("NAME")
|
| PA_PROJECTS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
JOB_BILL_RATE_SCHEDULE_ID
|
| PA_PROJECTS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EMP_BILL_RATE_SCHEDULE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | (15) | Yes | |
| NAME | VARCHAR2 | (30) | Yes | |
| SEGMENT1 | VARCHAR2 | (25) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| PROJECT_TYPE | VARCHAR2 | (20) | Yes | |
| CARRYING_OUT_ORGANIZATION_ID | NUMBER | (15) | Yes | |
| PUBLIC_SECTOR_FLAG | VARCHAR2 | (1) | Yes | |
| PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | |
| DESCRIPTION | VARCHAR2 | (250) | ||
| START_DATE | DATE | |||
| COMPLETION_DATE | DATE | |||
| CLOSED_DATE | DATE | |||
| DISTRIBUTION_RULE | VARCHAR2 | (30) | ||
| LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | ||
| NON_LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | ||
| RETENTION_INVOICE_FORMAT_ID | NUMBER | (15) | ||
| RETENTION_PERCENTAGE | NUMBER | (17) | ||
| BILLING_OFFSET | NUMBER | (15) | ||
| BILLING_CYCLE | NUMBER | (15) | ||
| LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (20) | ||
| LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | ||
| LABOR_SCHEDULE_FIXED_DATE | DATE | |||
| LABOR_SCHEDULE_DISCOUNT | NUMBER | (7) | ||
| NON_LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (30) | ||
| NON_LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | ||
| NON_LABOR_SCHEDULE_FIXED_DATE | DATE | |||
| NON_LABOR_SCHEDULE_DISCOUNT | NUMBER | (7) | ||
| LIMIT_TO_TXN_CONTROLS_FLAG | VARCHAR2 | (1) | ||
| PROJECT_LEVEL_FUNDING_FLAG | VARCHAR2 | (1) | ||
| INVOICE_COMMENT | VARCHAR2 | (240) | ||
| UNBILLED_RECEIVABLE_DR | NUMBER | (22) | ||
| UNEARNED_REVENUE_CR | NUMBER | (22) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| SEGMENT2 | VARCHAR2 | (25) | ||
| SEGMENT3 | VARCHAR2 | (25) | ||
| SEGMENT4 | VARCHAR2 | (25) | ||
| SEGMENT5 | VARCHAR2 | (25) | ||
| SEGMENT6 | VARCHAR2 | (25) | ||
| SEGMENT7 | VARCHAR2 | (25) | ||
| SEGMENT8 | VARCHAR2 | (25) | ||
| SEGMENT9 | VARCHAR2 | (25) | ||
| SEGMENT10 | VARCHAR2 | (25) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| COST_IND_RATE_SCH_ID | NUMBER | (15) | ||
| REV_IND_RATE_SCH_ID | NUMBER | (15) | ||
| INV_IND_RATE_SCH_ID | NUMBER | (15) | ||
| COST_IND_SCH_FIXED_DATE | DATE | |||
| REV_IND_SCH_FIXED_DATE | DATE | |||
| INV_IND_SCH_FIXED_DATE | DATE | |||
| LABOR_SCH_TYPE | VARCHAR2 | (1) | ||
| NON_LABOR_SCH_TYPE | VARCHAR2 | (1) | ||
| OVR_COST_IND_RATE_SCH_ID | NUMBER | (15) | ||
| OVR_REV_IND_RATE_SCH_ID | NUMBER | (15) | ||
| OVR_INV_IND_RATE_SCH_ID | NUMBER | (15) | ||
| TEMPLATE_FLAG | VARCHAR2 | (1) | ||
| VERIFICATION_DATE | DATE | |||
| CREATED_FROM_PROJECT_ID | NUMBER | (15) | ||
| TEMPLATE_START_DATE_ACTIVE | DATE | |||
| TEMPLATE_END_DATE_ACTIVE | DATE | |||
| ORG_ID | NUMBER | (15) | ||
| PM_PRODUCT_CODE | VARCHAR2 | (30) | ||
| PM_PROJECT_REFERENCE | VARCHAR2 | (25) | ||
| ACTUAL_START_DATE | DATE | |||
| ACTUAL_FINISH_DATE | DATE | |||
| EARLY_START_DATE | DATE | |||
| EARLY_FINISH_DATE | DATE | |||
| LATE_START_DATE | DATE | |||
| LATE_FINISH_DATE | DATE | |||
| SCHEDULED_START_DATE | DATE | |||
| SCHEDULED_FINISH_DATE | DATE | |||
| BILLING_CYCLE_ID | NUMBER | (15) | ||
| ADW_NOTIFY_FLAG | VARCHAR2 | (1) | ||
| WF_STATUS_CODE | VARCHAR2 | (30) | ||
| OUTPUT_TAX_CODE | VARCHAR2 | (50) | Indicates whether tax rate defined for the project will be used for cust omer invoices | |
| RETENTION_TAX_CODE | VARCHAR2 | (50) | Indicates whether tax rate defined for the retention will be used for cu stomer invoices | |
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Yes | |
| PROJECT_RATE_DATE | DATE | |||
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
| CC_PROCESS_LABOR_FLAG | VARCHAR2 | (1) | Yes | |
| LABOR_TP_SCHEDULE_ID | NUMBER | |||
| LABOR_TP_FIXED_DATE | DATE | |||
| CC_PROCESS_NL_FLAG | VARCHAR2 | (1) | Yes | |
| NL_TP_SCHEDULE_ID | NUMBER | |||
| NL_TP_FIXED_DATE | DATE | |||
| CC_TAX_TASK_ID | NUMBER | |||
| BILL_JOB_GROUP_ID | NUMBER | (15) | Determines which Job Group will be used for Billing functions for the project | |
| COST_JOB_GROUP_ID | NUMBER | (15) | Determines which Job Group will be used for Costing functions for the project | |
| ROLE_LIST_ID | NUMBER | (15) | Role_List is a list of allowable roles that are displayed when the Key/Team members are assigned | |
| WORK_TYPE_ID | NUMBER | (15) | Work_Types are predefined types of work, for example, Vacation, Training, and Administration. | |
| CALENDAR_ID | NUMBER | (15) | Define a calendar with calendar exceptions - primarily public holidays | |
| LOCATION_ID | NUMBER | (15) | Define a Project work site location. | |
| PROBABILITY_MEMBER_ID | NUMBER | (15) | Project probability represents the probability of a project becoming approved. It is used as a weighting average for reporting | |
| PROJECT_VALUE | NUMBER | Project value is used in reporting. For contract projects, it is the revenue amount. For capital and indirect projects, it is the cost amount. It is not assumed that the cost amount is raw or burdened. | ||
| EXPECTED_APPROVAL_DATE | DATE | The expected date of the project approval. This is used for information purposes only. | ||
| RECORD_VERSION_NUMBER | NUMBER | (15) | Storing Locking sequence number | |
| INITIAL_TEAM_TEMPLATE_ID | NUMBER | (15) | The Team template which you want to add to this new project. | |
| JOB_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the job based bill rate schedule ID | ||
| EMP_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the employee based bill rate schedule ID | ||
| COMPETENCE_MATCH_WT | NUMBER | |||
| AVAILABILITY_MATCH_WT | NUMBER | |||
| JOB_LEVEL_MATCH_WT | NUMBER | |||
| ENABLE_AUTOMATED_SEARCH | VARCHAR2 | (1) | ||
| SEARCH_MIN_AVAILABILITY | NUMBER | |||
| SEARCH_ORG_HIER_ID | NUMBER | (15) | ||
| SEARCH_STARTING_ORG_ID | NUMBER | (15) | ||
| SEARCH_COUNTRY_CODE | VARCHAR2 | (2) | ||
| MIN_CAND_SCORE_REQD_FOR_NOM | NUMBER | |||
| NON_LAB_STD_BILL_RT_SCH_ID | NUMBER | (15) | ||
| INVPROC_CURRENCY_TYPE | VARCHAR2 | (30) | ||
| REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PROJECT_BIL_RATE_DATE_CODE | VARCHAR2 | (30) | ||
| PROJECT_BIL_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_BIL_RATE_DATE | DATE | |||
| PROJECT_BIL_EXCHANGE_RATE | NUMBER | |||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PROJFUNC_BIL_RATE_DATE_CODE | VARCHAR2 | (30) | ||
| PROJFUNC_BIL_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_BIL_RATE_DATE | DATE | |||
| PROJFUNC_BIL_EXCHANGE_RATE | NUMBER | |||
| FUNDING_RATE_DATE_CODE | VARCHAR2 | (30) | ||
| FUNDING_RATE_TYPE | VARCHAR2 | (30) | ||
| FUNDING_RATE_DATE | DATE | |||
| FUNDING_EXCHANGE_RATE | NUMBER | |||
| BASELINE_FUNDING_FLAG | VARCHAR2 | (1) | ||
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_COST_RATE_DATE | DATE | |||
| INV_BY_BILL_TRANS_CURR_FLAG | VARCHAR2 | (1) | ||
| MULTI_CURRENCY_BILLING_FLAG | VARCHAR2 | (1) | ||
| SPLIT_COST_FROM_WORKPLAN_FLAG | VARCHAR2 | (1) | ||
| SPLIT_COST_FROM_BILL_FLAG | VARCHAR2 | (1) | ||
| ASSIGN_PRECEDES_TASK | VARCHAR2 | (1) | ||
| PRIORITY_CODE | VARCHAR2 | (30) | ||
| RETN_BILLING_INV_FORMAT_ID | NUMBER | (15) | ||
| RETN_ACCOUNTING_FLAG | VARCHAR2 | (1) | ||
| ADV_ACTION_SET_ID | NUMBER | (15) | ||
| START_ADV_ACTION_SET_FLAG | VARCHAR2 | (1) | ||
| REVALUATE_FUNDING_FLAG | VARCHAR2 | (1) | This column indicates whther the funding has to be revaluated or not. | |
| INCLUDE_GAINS_LOSSES_FLAG | VARCHAR2 | (1) | This column indicates whether realized gains and losses shold be included in project revenue or not. | |
| TARGET_START_DATE | DATE | The user-specified start date of the project. | ||
| TARGET_FINISH_DATE | DATE | The user-specified finish date of the project. | ||
| BASELINE_START_DATE | DATE | The baseline start date of the project. | ||
| BASELINE_FINISH_DATE | DATE | The baseline finish date of the project. | ||
| SCHEDULED_AS_OF_DATE | DATE | The scheduled as of date of the project. | ||
| BASELINE_AS_OF_DATE | DATE | The baseline as of date of the project. | ||
| LABOR_DISC_REASON_CODE | VARCHAR2 | (30) | Allow user to enter discount reason at project level for Labor | |
| NON_LABOR_DISC_REASON_CODE | VARCHAR2 | (30) | Allow user to enter discount reason at project level for Non-Labor | |
| SECURITY_LEVEL | NUMBER | Indicates whether a project is public or private 0 - Indicates project is private 100 - Indicates project is public | ||
| ACTUAL_AS_OF_DATE | DATE | The publish date for the actual start and actual dates for the project | ||
| SCHEDULED_DURATION | NUMBER | Duration between scheduled start and scheduled finish date using work ca lendar | ||
| BASELINE_DURATION | NUMBER | Duration between baseline start and baseline finish date using work cale ndar | ||
| ACTUAL_DURATION | NUMBER | Duration between actual start and actual finish date using work calendar | ||
| LONG_NAME | VARCHAR2 | (240) | ||
| BTC_COST_BASE_REV_CODE | VARCHAR2 | (90) | Bill Transaction Currency for Cost Based Revenue | |
| ASSET_ALLOCATION_METHOD | VARCHAR2 | (30) | Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level. | |
| CAPITAL_EVENT_PROCESSING | VARCHAR2 | (30) | Capital Event Processing method. Used to determine when cost and assets are grouped for capitalization or retirement adjustment processing. | |
| CINT_RATE_SCH_ID | NUMBER | (15) | Capital Interest Rate Schedule identifier. | |
| CINT_ELIGIBLE_FLAG | VARCHAR2 | (1) | Flag used to determine whether the project is eligible for capitalized interest. | |
| CINT_STOP_DATE | DATE | Stop date for capital interest calculation. | ||
| SYS_PROGRAM_FLAG | VARCHAR2 | (1) | Flag to determine whether the project is a program or not. | |
| STRUCTURE_SHARING_CODE | VARCHAR2 | (30) | Indicates how the financial and workplan structures are split or shared. | |
| ENABLE_TOP_TASK_CUSTOMER_FLAG | VARCHAR2 | (1) | Indicates if customers can be associated at the top task level | |
| ENABLE_TOP_TASK_INV_MTH_FLAG | VARCHAR2 | (1) | Indicates if invoice method can be associated at the top task level | |
| REVENUE_ACCRUAL_METHOD | VARCHAR2 | (30) | Defines the revenue accrual method for the project | |
| INVOICE_METHOD | VARCHAR2 | (30) | Defines the invoicing method for the project | |
| PROJFUNC_ATTR_FOR_AR_FLAG | VARCHAR2 | (1) | Use Project Functional Currency Conversion Attributes for Receivables Functional Currency | |
| PJI_SOURCE_FLAG | VARCHAR2 | (1) | ||
| ALLOW_MULTI_PROGRAM_ROLLUP | VARCHAR2 | (1) | Option to allow user to rollup to multiple programs | |
| PROJ_REQ_RES_FORMAT_ID | NUMBER | Indicates the planning resource format for project requirement creation | ||
| PROJ_ASGMT_RES_FORMAT_ID | NUMBER | Indicates the planning resource format for project assignment creation | ||
| FUNDING_APPROVAL_STATUS_CODE | VARCHAR2 | (30) | Indicates the funding approval status code for project | |
| REVTRANS_CURRENCY_TYPE | VARCHAR2 | (30) | Revenue Transaction Currency Type | |
| DATE_EFF_FUNDS_CONSUMPTION | VARCHAR2 | (1) | Date effective funds consumption flag. | |
| AR_REC_NOTIFY_FLAG | VARCHAR2 | (1) | Yes | Flag to decide if the PM should be notified when a receipt is applied. |
| AUTO_RELEASE_PWP_INV | VARCHAR2 | (1) | Yes | Flag to decide if the Pay When Paid hold on linked supplier invoices must be automatically released by the concurrent program. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, NAME
, SEGMENT1
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, PUBLIC_SECTOR_FLAG
, PROJECT_STATUS_CODE
, DESCRIPTION
, START_DATE
, COMPLETION_DATE
, CLOSED_DATE
, DISTRIBUTION_RULE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, RETENTION_INVOICE_FORMAT_ID
, RETENTION_PERCENTAGE
, BILLING_OFFSET
, BILLING_CYCLE
, LABOR_STD_BILL_RATE_SCHDL
, LABOR_BILL_RATE_ORG_ID
, LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT
, NON_LABOR_STD_BILL_RATE_SCHDL
, NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_SCHEDULE_FIXED_DATE
, NON_LABOR_SCHEDULE_DISCOUNT
, LIMIT_TO_TXN_CONTROLS_FLAG
, PROJECT_LEVEL_FUNDING_FLAG
, INVOICE_COMMENT
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID
, COST_IND_SCH_FIXED_DATE
, REV_IND_SCH_FIXED_DATE
, INV_IND_SCH_FIXED_DATE
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, OVR_COST_IND_RATE_SCH_ID
, OVR_REV_IND_RATE_SCH_ID
, OVR_INV_IND_RATE_SCH_ID
, TEMPLATE_FLAG
, VERIFICATION_DATE
, CREATED_FROM_PROJECT_ID
, TEMPLATE_START_DATE_ACTIVE
, TEMPLATE_END_DATE_ACTIVE
, ORG_ID
, PM_PRODUCT_CODE
, PM_PROJECT_REFERENCE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, EARLY_START_DATE
, EARLY_FINISH_DATE
, LATE_START_DATE
, LATE_FINISH_DATE
, SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE
, BILLING_CYCLE_ID
, ADW_NOTIFY_FLAG
, WF_STATUS_CODE
, OUTPUT_TAX_CODE
, RETENTION_TAX_CODE
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, CC_PROCESS_LABOR_FLAG
, LABOR_TP_SCHEDULE_ID
, LABOR_TP_FIXED_DATE
, CC_PROCESS_NL_FLAG
, NL_TP_SCHEDULE_ID
, NL_TP_FIXED_DATE
, CC_TAX_TASK_ID
, BILL_JOB_GROUP_ID
, COST_JOB_GROUP_ID
, ROLE_LIST_ID
, WORK_TYPE_ID
, CALENDAR_ID
, LOCATION_ID
, PROBABILITY_MEMBER_ID
, PROJECT_VALUE
, EXPECTED_APPROVAL_DATE
, RECORD_VERSION_NUMBER
, INITIAL_TEAM_TEMPLATE_ID
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT
, ENABLE_AUTOMATED_SEARCH
, SEARCH_MIN_AVAILABILITY
, SEARCH_ORG_HIER_ID
, SEARCH_STARTING_ORG_ID
, SEARCH_COUNTRY_CODE
, MIN_CAND_SCORE_REQD_FOR_NOM
, NON_LAB_STD_BILL_RT_SCH_ID
, INVPROC_CURRENCY_TYPE
, REVPROC_CURRENCY_CODE
, PROJECT_BIL_RATE_DATE_CODE
, PROJECT_BIL_RATE_TYPE
, PROJECT_BIL_RATE_DATE
, PROJECT_BIL_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_BIL_RATE_DATE_CODE
, PROJFUNC_BIL_RATE_TYPE
, PROJFUNC_BIL_RATE_DATE
, PROJFUNC_BIL_EXCHANGE_RATE
, FUNDING_RATE_DATE_CODE
, FUNDING_RATE_TYPE
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, BASELINE_FUNDING_FLAG
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, INV_BY_BILL_TRANS_CURR_FLAG
, MULTI_CURRENCY_BILLING_FLAG
, SPLIT_COST_FROM_WORKPLAN_FLAG
, SPLIT_COST_FROM_BILL_FLAG
, ASSIGN_PRECEDES_TASK
, PRIORITY_CODE
, RETN_BILLING_INV_FORMAT_ID
, RETN_ACCOUNTING_FLAG
, ADV_ACTION_SET_ID
, START_ADV_ACTION_SET_FLAG
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, TARGET_START_DATE
, TARGET_FINISH_DATE
, BASELINE_START_DATE
, BASELINE_FINISH_DATE
, SCHEDULED_AS_OF_DATE
, BASELINE_AS_OF_DATE
, LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE
, SECURITY_LEVEL
, ACTUAL_AS_OF_DATE
, SCHEDULED_DURATION
, BASELINE_DURATION
, ACTUAL_DURATION
, LONG_NAME
, BTC_COST_BASE_REV_CODE
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID
, CINT_ELIGIBLE_FLAG
, CINT_STOP_DATE
, SYS_PROGRAM_FLAG
, STRUCTURE_SHARING_CODE
, ENABLE_TOP_TASK_CUSTOMER_FLAG
, ENABLE_TOP_TASK_INV_MTH_FLAG
, REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD
, PROJFUNC_ATTR_FOR_AR_FLAG
, PJI_SOURCE_FLAG
, ALLOW_MULTI_PROGRAM_ROLLUP
, PROJ_REQ_RES_FORMAT_ID
, PROJ_ASGMT_RES_FORMAT_ID
, FUNDING_APPROVAL_STATUS_CODE
, REVTRANS_CURRENCY_TYPE
, DATE_EFF_FUNDS_CONSUMPTION
, AR_REC_NOTIFY_FLAG
, AUTO_RELEASE_PWP_INV
FROM PA.PA_PROJECTS_ALL;
PA.PA_PROJECTS_ALL does not reference any database object
PA.PA_PROJECTS_ALL is referenced by following:
APPS
ALR_PA_PROJECTS_ALL_IAR
PA_ADW_PROJECTS_T1
PA_PJI_PROJECTS_T1
PA_PJI_PROJECTS_T2
PA_PJI_PROJECTS_T3
PA_PROJECTS
PA_PROJECTS_ALL
|
|
|
|