[Home] [Help] [Dependency Information]

TABLE: PSA.PSA_BC_REPORT_EVENTS_GT

Object Details

Object Name:	PSA_BC_REPORT_EVENTS_GT
Object Type:	TABLE
Owner:	PSA
FND Design Data:	PSA.PSA_BC_REPORT_EVENTS_GT
Subobject Name:
Status:	VALID

This is an interface table for Budgetary Control Results Report. Product teams insert data in this table prior to invoking the report. Data can be inserted in two ways: By Packet, By Event. If event is passed, the corresponding transaction distribution identifier columns can be populated to further filter records within an event. If packet is passed, the report displays all rows included within that packet.

Temporary Table Details

PSA.PSA_BC_REPORT_EVENTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT EVENT_ID
,      PACKET_ID
,      SOURCE_DISTRIBUTION_TYPE
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
FROM PSA.PSA_BC_REPORT_EVENTS_GT;

Dependencies

[top of page]

PSA.PSA_BC_REPORT_EVENTS_GT does not reference any database object

PSA.PSA_BC_REPORT_EVENTS_GT is referenced by following:

APPS

PSA_BC_REPORT_EVENTS_GT