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: GMS.GMS_BC_PACKETS_SUMMARY

Object Details

Object Name:	GMS_BC_PACKETS_SUMMARY
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_BC_PACKETS_SUMMARY
Subobject Name:
Status:	VALID

This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. After the funds check process ends, records are deleted from this table.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_BC_PACKETS_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PACKET_ID BUDGET_VERSION_ID BUD_TASK_ID RESOURCE_LIST_MEMBER_ID BUDGET_PERIOD_START_DATE BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PACKET_ID BUDGET_VERSION_ID BUD_TASK_ID PARENT_RESOURCE_ID BUDGET_PERIOD_START_DATE BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N3	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PACKET_ID BUDGET_VERSION_ID BUD_TASK_ID BUDGET_PERIOD_START_DATE BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N4	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PACKET_ID BUDGET_VERSION_ID TOP_TASK_ID BUDGET_PERIOD_START_DATE BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N5	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	PACKET_ID BUDGET_VERSION_ID BUDGET_PERIOD_START_DATE BUDGET_PERIOD_END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PACKET_ID	NUMBER	(15)	Yes	Packet Id
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Budget Version id
BUD_TASK_ID	NUMBER	(15)		Budgeted Task Id
TOP_TASK_ID	NUMBER			Top task id
BUD_RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Budgeted resource List member Id
PARENT_RESOURCE_ID	NUMBER			Parent Resource Id
BUDGET_PERIOD_START_DATE	DATE			Budget Period Start Date
BUDGET_PERIOD_END_DATE	DATE			Budget Period End Date
CREATION_DATE	DATE			Creation Date
ACTUAL_APPROVED	NUMBER			Actual approved
ACTUAL_PENDING	NUMBER			Actual Pending
ENC_APPROVED	NUMBER			Encumbrance approved
ENC_PENDING	NUMBER			Encumbrance Pending
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource List Member Id

Query Text

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


SELECT PACKET_ID
,      BUDGET_VERSION_ID
,      BUD_TASK_ID
,      TOP_TASK_ID
,      BUD_RESOURCE_LIST_MEMBER_ID
,      PARENT_RESOURCE_ID
,      BUDGET_PERIOD_START_DATE
,      BUDGET_PERIOD_END_DATE
,      CREATION_DATE
,      ACTUAL_APPROVED
,      ACTUAL_PENDING
,      ENC_APPROVED
,      ENC_PENDING
,      RESOURCE_LIST_MEMBER_ID
FROM GMS.GMS_BC_PACKETS_SUMMARY;

Dependencies

[top of page]

GMS.GMS_BC_PACKETS_SUMMARY does not reference any database object

GMS.GMS_BC_PACKETS_SUMMARY is referenced by following:

APPS: GMS_BC_PACKETS_SUMMARY