DBA Data[Home] [Help] [Dependency Information]

TABLE: PSA.PSA_OPTION_DETAILS_GT

Object Details
Object Name: PSA_OPTION_DETAILS_GT
Object Type: TABLE
Owner: PSA
FND Design Data: TablePSA.PSA_OPTION_DETAILS_GT
Subobject Name:
Status: VALID

This table is created to improve performance of funds checker. It is populated with the budgetary control parameters for each packet, journal source and journal category which are later used by funds checker during budgetary control processing.

Temporary Table Details

PSA.PSA_OPTION_DETAILS_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: Tablespace
PCT Free: 10
PCT Used: 40
Unique Key: PSA_OPTION_DETAILS_GT_U1
  1. ColumnPACKET_ID
  2. ColumnJE_SOURCE_NAME
  3. ColumnJE_CATEGORY_NAME
Indexes
Index Type Uniqueness Tablespace Column
PSA_OPTION_DETAILS_GT_U1 NORMAL UNIQUE Tablespace ColumnPACKET_ID
ColumnJE_SOURCE_NAME
ColumnJE_CATEGORY_NAME
Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER
Yes Packet Identifier
JE_SOURCE_NAME VARCHAR2 (25) Yes Je Source Name
JE_CATEGORY_NAME VARCHAR2 (25) Yes Je Category Name
GL_BC_OPTION_SOURCE VARCHAR2 (25) Yes JE Source Name
GL_BC_OPTION_CATEGORY VARCHAR2 (25) Yes JE Category Name
FUNDS_CHECK_LEVEL_CODE VARCHAR2 (1) Yes Funds Check Level Code
OVERRIDE_AMOUNT NUMBER

Override Amount
TOLERANCE_PERCENTAGE NUMBER

Tolerance Percentage
TOLERANCE_AMOUNT NUMBER

Tolerance Amount
Query Text

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


SELECT PACKET_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      GL_BC_OPTION_SOURCE
,      GL_BC_OPTION_CATEGORY
,      FUNDS_CHECK_LEVEL_CODE
,      OVERRIDE_AMOUNT
,      TOLERANCE_PERCENTAGE
,      TOLERANCE_AMOUNT
FROM PSA.PSA_OPTION_DETAILS_GT;

Dependencies

[top of page]

PSA.PSA_OPTION_DETAILS_GT does not reference any database object

PSA.PSA_OPTION_DETAILS_GT is referenced by following:

SchemaAPPS
SynonymPSA_OPTION_DETAILS_GT