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_TSK_BGT_LINES_IT_ALL

Object Details

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

PA_TSK_BGT_LINES_IT_ALL stores task level budgets for
Oracle Project Analysis Collection Pack.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TSK_BGT_LINES_IT_ALL_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	TASK_BUDGET_LINE_KEY
PA_TSK_BGT_LINES_IT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TASK_ID PA_PERIOD_KEY RESOURCE_LIST_MEMBER_ID BUDGET_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_BUDGET_LINE_KEY	VARCHAR2	(500)	Yes	The identifier which uniquely identifies this row. This column value is created by concatenating task_id,pa_period_key,budget_type_code,owner_organization_id,resource_list_member_id,service_type_code and expenditure_type by '-'
TASK_ID	NUMBER	(15)	Yes	The identifier of the task to which this row belongs
PA_PERIOD_KEY	VARCHAR2	(40)	Yes	The identifier of the PA period(PA_PERIODS_IT) to which this row belongs
BUDGET_TYPE_CODE	VARCHAR2	(30)	Yes	The identifier of Budget Type for this row belongs
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
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		The identifier of the resource list member to which this row belongs
SERVICE_TYPE_CODE	VARCHAR2	(30)		The identifier of the service type to which this row belongs
OWNER_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization which owns this budget line
EXPENDITURE_TYPE	VARCHAR2	(30)		The expenditure type to which this row belongs
USER_COL1	VARCHAR2	(15)		Column that can be used to store user customizations for additional dimensions
USER_COL2	VARCHAR2	(15)		Column that can be used to store user customizations for additional dimensions
USER_COL3	VARCHAR2	(15)		Column that can be used to store user customizations for additional dimensions
USER_COL4	VARCHAR2	(15)		Column that can be used to store user customizations for additional dimensions
USER_COL5	VARCHAR2	(15)		Column that can be used to store user customizations for additional dimensions
USER_COL6	NUMBER			Column that can be used to store user customizations for additional measures
USER_COL7	NUMBER			Column that can be used to store user customizations for additional measures
USER_COL8	NUMBER			Column that can be used to store user customizations for additional measures
USER_COL9	NUMBER			Column that can be used to store user customizations for additional measures
USER_COL10	NUMBER			Column that can be used to store user customizations for additional measures
BGT_RAW_COST	NUMBER			The Budgeted raw cost amount
BGT_BURDENED_COST	NUMBER			The Budgeted burdened cost amount
BGT_REVENUE	NUMBER			The Budgeted revenue amount
BGT_QUANTITY	NUMBER			The Budgeted quantity
BGT_LABOR_QUANTITY	NUMBER			The Budgeted labor hours
BGT_UNIT_OF_MEASURE	VARCHAR2	(30)		The unit of measure for budgeted quantity
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
STATUS_CODE	VARCHAR2	(1)		The flag that indicates whether this row has any updates or not.
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations

Query Text

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


SELECT TASK_BUDGET_LINE_KEY
,      TASK_ID
,      PA_PERIOD_KEY
,      BUDGET_TYPE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      RESOURCE_LIST_MEMBER_ID
,      SERVICE_TYPE_CODE
,      OWNER_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      USER_COL1
,      USER_COL2
,      USER_COL3
,      USER_COL4
,      USER_COL5
,      USER_COL6
,      USER_COL7
,      USER_COL8
,      USER_COL9
,      USER_COL10
,      BGT_RAW_COST
,      BGT_BURDENED_COST
,      BGT_REVENUE
,      BGT_QUANTITY
,      BGT_LABOR_QUANTITY
,      BGT_UNIT_OF_MEASURE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS_CODE
,      ORG_ID
FROM PA.PA_TSK_BGT_LINES_IT_ALL;

Dependencies

[top of page]

PA.PA_TSK_BGT_LINES_IT_ALL does not reference any database object

PA.PA_TSK_BGT_LINES_IT_ALL is referenced by following:

PA: PA_TSK_BGT_LINES_IT_ALL#