[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJECTS_AMG_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_PROJECTS_AMG_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) | Yes | |
| NAME | VARCHAR2 | (30) | Yes | |
| LONG_NAME | VARCHAR2 | (240) | ||
| 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) | ||
| BILLING_CYCLE_ID | 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) | ||
| TEMPLATE_FLAG | VARCHAR2 | (1) | ||
| VERIFICATION_DATE | DATE | |||
| CREATED_FROM_PROJECT_ID | NUMBER | (15) | ||
| TEMPLATE_START_DATE_ACTIVE | DATE | |||
| NON_LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (30) | ||
| TEMPLATE_END_DATE_ACTIVE | DATE | |||
| 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) | ||
| 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 | |||
| ADW_NOTIFY_FLAG | VARCHAR2 | (1) | ||
| WF_STATUS_CODE | VARCHAR2 | (30) | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Yes | |
| PROJECT_RATE_DATE | DATE | |||
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
| OUTPUT_TAX_CODE | VARCHAR2 | (50) | ||
| RETENTION_TAX_CODE | VARCHAR2 | (50) | ||
| 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. | ||
| INITIAL_TEAM_TEMPLATE_ID | NUMBER | (15) | The Team template which you want to add to this new project. | |
| RECORD_VERSION_NUMBER | NUMBER | (15) | Stroing Record locking sequence number | |
| 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 | ||
| 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) | ||
| MULTI_CURRENCY_BILLING_FLAG | VARCHAR2 | (1) | ||
| 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 | |||
| INV_BY_BILL_TRANS_CURR_FLAG | VARCHAR2 | (1) | ||
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
| PROJFUNC_COST_RATE_DATE | DATE | |||
| ASSIGN_PRECEDES_TASK | VARCHAR2 | (1) | ||
| SPLIT_COST_FROM_WORKPLAN_FLAG | VARCHAR2 | (1) | ||
| SPLIT_COST_FROM_BILL_FLAG | 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) | ||
| 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. | ||
| 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. | |
| 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. | ||
| SECURITY_LEVEL | NUMBER | Indicates whether a project is public or private 0 - Indicates project is private 100 - Indicates project is public | ||
| 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 | |
| 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 calendar | ||
| BASELINE_DURATION | NUMBER | Duration between baseline start and baseline finish date using work calendar | ||
| ACTUAL_DURATION | NUMBER | Duration between actual start and actual finish date using work calendar | ||
| STRUCT_WORKPLAN_ENABLED | VARCHAR2 | (4000) | Indicates whether the workplan is enabled | |
| STRUCT_VERSIONS_ENABLED | VARCHAR2 | (4000) | Indicates whether workplan versioning is enabled | |
| STRUCT_SHARING_ENABLED | VARCHAR2 | (4000) | Indicates whether sharing workplan and financial structures is enabled | |
| STRUCT_AUTO_PUBLISH_ENABLED | VARCHAR2 | (4000) | Indicates whether workplan auto publishing is enabled | |
| STRUCT_APPROVAL_REQUIRED | VARCHAR2 | (4000) | Indicates whether workplan approval is required | |
| STRUCT_PUBLISH_ON_CREATE | VARCHAR2 | (4000) | Indicates whether the workplan is automatically published when it is first created | |
| 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 capitalizationor 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. | ||
| STRUCTURE_SHARING_CODE | VARCHAR2 | (30) | Indicates how the financial and workplan structures are split or shared. | |
| ENABLE_TOP_TASK_CUSTOMER_FLAG | VARCHAR2 | (1) | ||
| ENABLE_TOP_TASK_INV_MTH_FLAG | VARCHAR2 | (1) | ||
| REVENUE_ACCRUAL_METHOD | VARCHAR2 | (30) | ||
| INVOICE_METHOD | VARCHAR2 | (30) | ||
| PROJFUNC_ATTR_FOR_AR_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, NAME
, LONG_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
, BILLING_CYCLE_ID
, LABOR_STD_BILL_RATE_SCHDL
, LABOR_BILL_RATE_ORG_ID
, LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT
, TEMPLATE_FLAG
, VERIFICATION_DATE
, CREATED_FROM_PROJECT_ID
, TEMPLATE_START_DATE_ACTIVE
, NON_LABOR_STD_BILL_RATE_SCHDL
, TEMPLATE_END_DATE_ACTIVE
, 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
, 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
, ADW_NOTIFY_FLAG
, WF_STATUS_CODE
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, OUTPUT_TAX_CODE
, RETENTION_TAX_CODE
, 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
, INITIAL_TEAM_TEMPLATE_ID
, RECORD_VERSION_NUMBER
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, 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
, MULTI_CURRENCY_BILLING_FLAG
, 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
, INV_BY_BILL_TRANS_CURR_FLAG
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, ASSIGN_PRECEDES_TASK
, SPLIT_COST_FROM_WORKPLAN_FLAG
, SPLIT_COST_FROM_BILL_FLAG
, PRIORITY_CODE
, RETN_BILLING_INV_FORMAT_ID
, RETN_ACCOUNTING_FLAG
, ADV_ACTION_SET_ID
, START_ADV_ACTION_SET_FLAG
, TARGET_START_DATE
, TARGET_FINISH_DATE
, BASELINE_START_DATE
, BASELINE_FINISH_DATE
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, SCHEDULED_AS_OF_DATE
, BASELINE_AS_OF_DATE
, SECURITY_LEVEL
, LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE
, ACTUAL_AS_OF_DATE
, SCHEDULED_DURATION
, BASELINE_DURATION
, ACTUAL_DURATION
, STRUCT_WORKPLAN_ENABLED
, STRUCT_VERSIONS_ENABLED
, STRUCT_SHARING_ENABLED
, STRUCT_AUTO_PUBLISH_ENABLED
, STRUCT_APPROVAL_REQUIRED
, STRUCT_PUBLISH_ON_CREATE
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID
, CINT_ELIGIBLE_FLAG
, CINT_STOP_DATE
, STRUCTURE_SHARING_CODE
, ENABLE_TOP_TASK_CUSTOMER_FLAG
, ENABLE_TOP_TASK_INV_MTH_FLAG
, REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD
, PROJFUNC_ATTR_FOR_AR_FLAG
FROM APPS.PA_PROJECTS_AMG_V;
APPS
PA_PROJECTS
PA_PROJECT_STRUCTURE_UTILS
- show dependent code
PA_PROJ_ELEMENTS_UTILS
- show dependent code
PA_WORKPLAN_ATTR_UTILS
- show dependent code
APPS.PA_PROJECTS_AMG_V is not referenced by any database object
|
|
|
|