[Home] [Help] [Dependency Information]
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.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Event Identifier | |
PACKET_ID | NUMBER | (15) | Packet Identifier | |
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Source Distribution Type | |
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (15) | Transaction source distribution identifier | |
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (15) | Transaction source distribution identifier |
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;
PSA.PSA_BC_REPORT_EVENTS_GT does not reference any database object
PSA.PSA_BC_REPORT_EVENTS_GT is referenced by following:
|
|
|