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]

VIEW: APPS.PA_PROJECTS_V

Object Details

Object Name:	PA_PROJECTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJECTS_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
ROW_ID	ROWID	(10)
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)
BILLING_CYCLE_NAME	VARCHAR2	(30)
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)
TEMPLATE_FLAG	VARCHAR2	(1)
CREATED_FROM_PROJECT_ID	NUMBER	(15)
VERIFICATION_DATE	DATE
TEMPLATE_START_DATE_ACTIVE	DATE
TEMPLATE_END_DATE_ACTIVE	DATE
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
PROJECT_STATUS_M	VARCHAR2	(80)	Yes
DISTRIBUTION_RULE_M	VARCHAR2	(80)
DISTRIBUTION_RULE_DESCRIPTION	VARCHAR2	(250)
PROJECT_TYPE_CLASS_CODE	VARCHAR2	(30)
SERVICE_TYPE_CODE	VARCHAR2	(30)	Yes
BURDEN_COST_FLAG	VARCHAR2	(1)	Yes
INTERFACE_ASSET_COST_CODE	VARCHAR2	(1)
COST_SCH_OVERRIDE_FLAG	VARCHAR2	(1)
CC_PRVDR_FLAG	VARCHAR2	(1)
UPDATE_ALLOWED	VARCHAR2	(4000)
PM_PRODUCT_CODE	VARCHAR2	(30)
PM_PRODUCT_CODE_M	VARCHAR2	(80)
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
WF_STATUS_CODE	VARCHAR2	(30)
WF_IN_ROUTE_FLAG	VARCHAR2	(1)
PROJECT_SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes
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.
UNASSIGNED_TIME	VARCHAR2	(1)		This column specifies the desired project type to which all unassigned time of a resource should be designated.
ADMINISTRATIVE_FLAG	VARCHAR2	(1)		This column indicates the Administrative type of projects
INITIAL_TEAM_TEMPLATE_ID	NUMBER	(15)		The Team template which you want to add to this new project.
RECORD_VERSION_NUMBER	NUMBER	(15)		Storing 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)
ORG_ID	NUMBER	(15)
OPERATING_UNIT	VARCHAR2	(240)	Yes
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
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 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)
SYS_PROGRAM_FLAG	VARCHAR2	(1)
ALLOW_MULTI_PROGRAM_ROLLUP	VARCHAR2	(1)
PROJ_REQ_RES_FORMAT_ID	NUMBER
PROJ_ASGMT_RES_FORMAT_ID	NUMBER
PROJECT_TYPE_ID	NUMBER	(15)	Yes
FUNDING_APPROVAL_STATUS_CODE	VARCHAR2	(30)		Indicates the funding approval status code for project
FUNDING_APPROVAL_STATUS_NAME	VARCHAR2	(80)
REVTRANS_CURRENCY_TYPE	VARCHAR2	(30)
DATE_EFF_FUNDS_CONSUMPTION	VARCHAR2	(1)		Defines whether Date Effective Funds Consumption is enabled
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.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      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
,      BILLING_CYCLE_NAME
,      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
,      TEMPLATE_FLAG
,      CREATED_FROM_PROJECT_ID
,      VERIFICATION_DATE
,      TEMPLATE_START_DATE_ACTIVE
,      TEMPLATE_END_DATE_ACTIVE
,      ORGANIZATION_NAME
,      PROJECT_STATUS_M
,      DISTRIBUTION_RULE_M
,      DISTRIBUTION_RULE_DESCRIPTION
,      PROJECT_TYPE_CLASS_CODE
,      SERVICE_TYPE_CODE
,      BURDEN_COST_FLAG
,      INTERFACE_ASSET_COST_CODE
,      COST_SCH_OVERRIDE_FLAG
,      CC_PRVDR_FLAG
,      UPDATE_ALLOWED
,      PM_PRODUCT_CODE
,      PM_PRODUCT_CODE_M
,      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
,      WF_STATUS_CODE
,      WF_IN_ROUTE_FLAG
,      PROJECT_SYSTEM_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
,      UNASSIGNED_TIME
,      ADMINISTRATIVE_FLAG
,      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
,      ORG_ID
,      OPERATING_UNIT
,      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
,      BTC_COST_BASE_REV_CODE
,      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
,      SYS_PROGRAM_FLAG
,      ALLOW_MULTI_PROGRAM_ROLLUP
,      PROJ_REQ_RES_FORMAT_ID
,      PROJ_ASGMT_RES_FORMAT_ID
,      PROJECT_TYPE_ID
,      FUNDING_APPROVAL_STATUS_CODE
,      FUNDING_APPROVAL_STATUS_NAME
,      REVTRANS_CURRENCY_TYPE
,      DATE_EFF_FUNDS_CONSUMPTION
,      AR_REC_NOTIFY_FLAG
,      AUTO_RELEASE_PWP_INV
FROM APPS.PA_PROJECTS_V;