eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_PROJECTS_ALL

Object Details

Object Name:	PA_PROJECTS_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJECTS_ALL
Subobject Name:
Status:	VALID

PA_PROJECTS_ALL stores the highest units of work defined
in Oracle Projects at which funding can be
allocated and at which revenue, invoices, unbilled
receivables, and unearned revenue are generated and
maintained. At the project level, users can specify
the methods to be used for revenue accrual and
billing, and the invoice formats to be used for
invoicing.
A project is broken down into one or more tasks.
All projects can be funded by one or more agreements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID SEGMENT1
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_F1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("SEGMENT1"\|\|' - '\|\|"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_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PJT_ROLLUP_ENABLED_FLAG
PA_PROJECTS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PJT_ROLLUP_ENABLED_FLAG
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

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the project
NAME	VARCHAR2	(30)	Yes	User-defined name that uniquely identifies the project
SEGMENT1	VARCHAR2	(25)	Yes	The project number that uniquely identifies the project. The project number can be user-entered or system-generated as defined in the implementation options
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
PROJECT_TYPE	VARCHAR2	(20)	Yes	The project type that classifies the project and defaults project information upon project entry
CARRYING_OUT_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the organization that is responsible for the project work
PUBLIC_SECTOR_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the project is in the public sector or the private sector
PROJECT_STATUS_CODE	VARCHAR2	(30)	Yes	The status of the project.
DESCRIPTION	VARCHAR2	(250)		The description of the project
START_DATE	DATE			The date on which the project starts; expenditure items with item dates before the start date cannot be entered for the project
COMPLETION_DATE	DATE			The date on which the project is completed; expenditure items with item dates after the completion date cannot be entered for the project
CLOSED_DATE	DATE			The date that the project was closed by changing the project status to Closed
DISTRIBUTION_RULE	VARCHAR2	(30)		The distribution rule that specifies the contract project's revenue accrual and billing method
LABOR_INVOICE_FORMAT_ID	NUMBER	(15)		The identifier of the invoice format used to group and format labor expenditure items into invoice lines
NON_LABOR_INVOICE_FORMAT_ID	NUMBER	(15)		The identifier of the invoice format used to group and format non-labor expenditure items into invoice lines
RETENTION_INVOICE_FORMAT_ID	NUMBER	(15)		The identifier of the invoice format used to format a retention line on the project's invoices
RETENTION_PERCENTAGE	NUMBER	(17)		The percentage to be retained on each invoice generated for the project
BILLING_OFFSET	NUMBER	(15)		The number of days after the project start date when the first invoice for the project is created
BILLING_CYCLE	NUMBER	(15)		Obsolete
LABOR_STD_BILL_RATE_SCHDL	VARCHAR2	(20)		The labor standard bill rate schedule that defaults to new tasks created for the project
LABOR_BILL_RATE_ORG_ID	NUMBER	(15)		The identifier of the organization that owns the labor standard bill rate schedule
LABOR_SCHEDULE_FIXED_DATE	DATE			The fixed date used to determine the effective bill rates of the standard labor bill rate schedule. The project fixed date is a default for the task fixed date
LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)		The percentage to be discounted from the standard labor bill rate schedule. The project discount is a default for the task discount
NON_LABOR_STD_BILL_RATE_SCHDL	VARCHAR2	(30)		The non-labor standard bill rate schedule that defaults to new tasks created for the project
NON_LABOR_BILL_RATE_ORG_ID	NUMBER	(15)		The identifier of the organization that owns the non-labor standard bill rate schedule
NON_LABOR_SCHEDULE_FIXED_DATE	DATE			The fixed date used to determine the effective bill rates of the standard non-labor bill rate schedule. The project fixed date is a default for the task fixed date
NON_LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)		The percentage to be discounted from the standard non-labor bill rate schedule. The project discount is a default for the task discount
LIMIT_TO_TXN_CONTROLS_FLAG	VARCHAR2	(1)		Flag that indicates if users can only charge expenditures to the project that are listed in the transaction controls. If flag =Y, then only items listed in the controls are allowed. If flag =N or null, then items not listed are allowed
PROJECT_LEVEL_FUNDING_FLAG	VARCHAR2	(1)		Flag that indicates if the project is funded at the project level ('Y') or at the top task level (N'). This flag is set when the project is baselined
INVOICE_COMMENT	VARCHAR2	(240)		Free text comment that can be printed on an invoice. The invoice comment defined for the project is defaulted to the invoice comment for the draft invoices of the project
UNBILLED_RECEIVABLE_DR	NUMBER	(22)		The unbilled receivables balance for the project that is posted to Oracle General Ledger or Oracle Receivables. This value is maintained by the Transfer Revenue and Transfer Invoices processes
UNEARNED_REVENUE_CR	NUMBER	(22)		The unearned revenue balance for the project that is posted to Oracle General Ledger or Oracle Receivables. This value is maintained by the Transfer Revenue and Transfer Invoices processes
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Flag used with the project key flexfield. The project key flexfield is not implemented
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag used with the key flexfield. The project key flexfield is not implemented
SEGMENT2	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT3	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT4	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT5	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT6	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT7	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT8	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT9	VARCHAR2	(25)		Key flexfield segment - not implemented
SEGMENT10	VARCHAR2	(25)		Key flexfield segment - not implemented
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
COST_IND_RATE_SCH_ID	NUMBER	(15)		The identifier of default costing burden schedule
REV_IND_RATE_SCH_ID	NUMBER	(15)		The identifier of default revenue burden schedule
INV_IND_RATE_SCH_ID	NUMBER	(15)		The identifier of default invoice burden schedule
COST_IND_SCH_FIXED_DATE	DATE			The schedule fixed date of firm costing burden schedule
REV_IND_SCH_FIXED_DATE	DATE			The schedule fixed date of firm revenue burden schedule
INV_IND_SCH_FIXED_DATE	DATE			The schedule fixed date of firm invoice burden schedule
LABOR_SCH_TYPE	VARCHAR2	(1)		The schedule type of labor expenditure items
NON_LABOR_SCH_TYPE	VARCHAR2	(1)		The schedule type of non-labor expenditure items
OVR_COST_IND_RATE_SCH_ID	NUMBER	(15)		This column is not used
OVR_REV_IND_RATE_SCH_ID	NUMBER	(15)		This column is not used
OVR_INV_IND_RATE_SCH_ID	NUMBER	(15)		This column is not used
TEMPLATE_FLAG	VARCHAR2	(1)		Indicates whether the project is a Template or Not
VERIFICATION_DATE	DATE			Not currently used
CREATED_FROM_PROJECT_ID	NUMBER	(15)		Holds the Project_id of the template corresponding to the source project. This value would be null for templates
TEMPLATE_START_DATE_ACTIVE	DATE			The Effective start date of the Template
TEMPLATE_END_DATE_ACTIVE	DATE			Last effective date of the template
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
PM_PRODUCT_CODE	VARCHAR2	(30)		The identifier of the external project management system from which the project was imported.
PM_PROJECT_REFERENCE	VARCHAR2	(25)		The identifier of the project in the external project management system from which the project was imported.
ACTUAL_START_DATE	DATE			The actual start date of the project. Applicable only for a project that has originated from an external system.
ACTUAL_FINISH_DATE	DATE			The actual end date of the project. Applicable only for a project that has originated from an external system.
EARLY_START_DATE	DATE			The early start date of the project. Applicable only for a project that has originated from an external system.
EARLY_FINISH_DATE	DATE			The early finish date of the project. Applicable only for a project that has originated from an external system.
LATE_START_DATE	DATE			The late start date of the project. Applicable only for a project that has originated from an external system.
LATE_FINISH_DATE	DATE			The late finish date of the project. Applicable only for a project that has originated from an external system.
SCHEDULED_START_DATE	DATE			The scheduled start date of the project. Applicable only for a project that has originated from an external system.
SCHEDULED_FINISH_DATE	DATE			The scheduled finish date of the project. Applicable only for a project that has originated from an external system.
BILLING_CYCLE_ID	NUMBER	(15)		The identifier of the billing cycle which applies to the project
ADW_NOTIFY_FLAG	VARCHAR2	(1)		The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
WF_STATUS_CODE	VARCHAR2	(30)		Indicates the status of the workflow associated with the project
OUTPUT_TAX_CODE	VARCHAR2	(50)		Indicates whether tax rate defined for Projects will be used for Customer Invoices
RETENTION_TAX_CODE	VARCHAR2	(50)		Indicates whether tax rate defined for retention will be used for Customer Invoices
PROJECT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code of the project
ALLOW_CROSS_CHARGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether cross charge are allowed
PROJECT_RATE_DATE	DATE			Default value for project rate date which can be overridden at task
PROJECT_RATE_TYPE	VARCHAR2	(30)		Default value for project rate type which can be overridden at task
CC_PROCESS_LABOR_FLAG	VARCHAR2	(1)	Yes	Flag that indicates cross charge processing is to be performed for labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date.
LABOR_TP_SCHEDULE_ID	NUMBER			Identifier for transfer price schedule to use for cross charged labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. It cc_process_labor_flag is set to Y, this field is required.
LABOR_TP_FIXED_DATE	DATE			Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date.
CC_PROCESS_NL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates cross charge processing is to be performed for n on-labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date.
NL_TP_SCHEDULE_ID	NUMBER			Identifier for transfer price schedule to use for cross charged non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_nl_flag is set to Y, this field is required.
NL_TP_FIXED_DATE	DATE			Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for non-labor transactions. This is defaulted to a project from the project template. This value for the project isa default for the task fixed date.
CC_TAX_TASK_ID	NUMBER			Identifier of the task to which intercompany tax items on the intercompany AP invoice are charged.
BILL_JOB_GROUP_ID	NUMBER	(15)		Determines which Job Group will be used for Billing functionality.
COST_JOB_GROUP_ID	NUMBER	(15)		Determines which Job Group will be used for Costing functionality.
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			The OPPORTUNITY_VALUE converted to the project functional currency.
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 his new project.
JOB_BILL_RATE_SCHEDULE_ID	NUMBER			Stores the Job based Bill Rate Schedule ID for the project
EMP_BILL_RATE_SCHEDULE_ID	NUMBER			Stores the Employee based Bill Rate Schedule ID for the project
COMPETENCE_MATCH_WT	NUMBER			Weighting value for competence match used to calculate Score
AVAILABILITY_MATCH_WT	NUMBER			Weighting value for availability match used to calculate Score
JOB_LEVEL_MATCH_WT	NUMBER			Weighting value for job level match used to calculate Score
ENABLE_AUTOMATED_SEARCH	VARCHAR2	(1)		Automated Candidate Nomination is done for the requirements on a project only if the Enable checkbox is selected.
SEARCH_MIN_AVAILABILITY	NUMBER			The minimum required availability of a resource to be returned in the search result
SEARCH_ORG_HIER_ID	NUMBER	(15)		Organization Hierarchy for the search
SEARCH_STARTING_ORG_ID	NUMBER	(15)		Starting Organization for the search
SEARCH_COUNTRY_CODE	VARCHAR2	(2)		Country for the search
MIN_CAND_SCORE_REQD_FOR_NOM	NUMBER			Minimum score required for a resource to be nominated as candidate on a requirement
NON_LAB_STD_BILL_RT_SCH_ID	NUMBER	(15)		Non labor standard bill rate schedule ID.
INVPROC_CURRENCY_TYPE	VARCHAR2	(30)		Invoice processing currency code
REVPROC_CURRENCY_CODE	VARCHAR2	(15)		Revenue processing currency code. Project functional currency. Currently the project functional currency is the same as the revenue processing currency.
PROJECT_BIL_RATE_DATE_CODE	VARCHAR2	(30)		Exchange rate date type for determining the date to use for conversion betweenfrom bill transaction currency/ funding currency to to project currency for customer billing.
PROJECT_BIL_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency/ funding currency to project currency for customer billing.
PROJECT_BIL_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency/ funding currency to project currency if Fixed Date rate date type is used for customer billing.
PROJECT_BIL_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency/ funding currency to project currency if User exchange rate type is used.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency. The default value is the value entered for the associated ledger.
PROJFUNC_BIL_RATE_DATE_CODE	VARCHAR2	(30)		Exchange rate date type for determining the date to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing.
PROJFUNC_BIL_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing.
PROJFUNC_BIL_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency/funding currency to project functional currency if Fixed Date rate date type is used for customer billing.
PROJFUNC_BIL_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency/ funding currency to project functional if User exchange rate type is used.
FUNDING_RATE_DATE_CODE	VARCHAR2	(30)		Exchange rate date type for determining the date to use for conversion from bill transaction currency to funding currency for customer billing.
FUNDING_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to funding currency for customer billing.
FUNDING_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used for customer billing.
FUNDING_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to project or functional currency if User exchange rate type is used.
BASELINE_FUNDING_FLAG	VARCHAR2	(1)		Flag indicating whether the funding can be baselined without revenue budget.
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		Default value for the project functional cost rate
PROJFUNC_COST_RATE_DATE	DATE			Default value for the project functional cost rate date.
INV_BY_BILL_TRANS_CURR_FLAG	VARCHAR2	(1)		Flag indicating if invoicing is by bill transaction currency for this project.
MULTI_CURRENCY_BILLING_FLAG	VARCHAR2	(1)		Flag indicating if multi-currency billing is allowed for this project
SPLIT_COST_FROM_WORKPLAN_FLAG	VARCHAR2	(1)		Not Used
SPLIT_COST_FROM_BILL_FLAG	VARCHAR2	(1)		Not Used
ASSIGN_PRECEDES_TASK	VARCHAR2	(1)		Flag to determine if assignment level attributes override task level attributes.
PRIORITY_CODE	VARCHAR2	(30)		Indicates priority of the project.
RETN_BILLING_INV_FORMAT_ID	NUMBER	(15)		The identifier of Retention Billing Invoice Format.
RETN_ACCOUNTING_FLAG	VARCHAR2	(1)		Indicates the retention accounting is enabled for the project
ADV_ACTION_SET_ID	NUMBER	(15)		Indicates the default advertisement action set of the project or the project template.
START_ADV_ACTION_SET_FLAG	VARCHAR2	(1)		Specify whether the advertisement action set will be started immediately after a requirement is created.
REVALUATE_FUNDING_FLAG	VARCHAR2	(1)		This column indicates whether the funding has to be revaluated or not. Valid values are Y or N
INCLUDE_GAINS_LOSSES_FLAG	VARCHAR2	(1)		This column indicates whether gains and losses to be included in project revenue or not. Valid values are Y or N
TARGET_START_DATE	DATE			The Target Start Date for the project.
TARGET_FINISH_DATE	DATE			The Target Finish Date for 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 publish date for the Scheduled Start and Finish dates for the project.
BASELINE_AS_OF_DATE	DATE			The baseline date for the Baseline Start and Finish Dates for the project.
LABOR_DISC_REASON_CODE	VARCHAR2	(30)		Reason code for labor discount
NON_LABOR_DISC_REASON_CODE	VARCHAR2	(30)		Reason code for non labor discount
SECURITY_LEVEL	NUMBER			Indicates whether a project is public or private:0 - Indicates project is private100 - Indicates project is public
ACTUAL_AS_OF_DATE	DATE			The publish date for the project Actual Start and Actual Finish Dates.
SCHEDULED_DURATION	NUMBER			Duration between the Scheduled Start and Finish Dates using the project work calendar.
BASELINE_DURATION	NUMBER			Duration between the Baseline Start and Finish Dates using the project work calendar.
ACTUAL_DURATION	NUMBER			Duration between the Actual Start and Finish Dates using the project work calendar.
LONG_NAME	VARCHAR2	(240)		Project Long Name
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 whether Customer at top task is enabled for Project or Not.
ENABLE_TOP_TASK_INV_MTH_FLAG	VARCHAR2	(1)		Indicates whether Invoice Method at Top Task is enabled or not.
REVENUE_ACCRUAL_METHOD	VARCHAR2	(30)		Indicates the Revenue Method for Project.
INVOICE_METHOD	VARCHAR2	(30)		Indicates the Invoice Method for Project.
PROJFUNC_ATTR_FOR_AR_FLAG	VARCHAR2	(1)		Use Project Functional Currency Conversion Attributes for Receivables Functional Currency.
PJI_SOURCE_FLAG	VARCHAR2	(1)		Flag to determine whether project was implemented in old PSI model or new Project Performance model.
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)		Funding Status Approval Code
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.
BILL_LABOR_ACCRUAL	VARCHAR2	(1)		Bill labor accrual
ADJ_ON_STD_INV	VARCHAR2	(2)		Adjustments included on standard Invoice
CBS_VERSION_ID	NUMBER	(15)
CBS_ENABLE_FLAG	VARCHAR2	(1)
PJT_ROLLUP_ENABLED_FLAG	VARCHAR2	(1)
OLAP_GROUP	NUMBER
OLAP_TASK_ID	NUMBER

Query Text

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
,      BILL_LABOR_ACCRUAL
,      ADJ_ON_STD_INV
,      CBS_VERSION_ID
,      CBS_ENABLE_FLAG
,      PJT_ROLLUP_ENABLED_FLAG
,      OLAP_GROUP
,      OLAP_TASK_ID
FROM PA.PA_PROJECTS_ALL;

Dependencies

[top of page]

PA.PA_PROJECTS_ALL does not reference any database object

PA.PA_PROJECTS_ALL is referenced by following:

PA: PA_PROJECTS_ALL#