[Home] [Help] [Dependency Information]

TABLE: APPS.PSA_BC_RESULTS_GT

Object Details

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

Temporary Table Details

APPS.PSA_BC_RESULTS_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 APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      APPLICATION_NAME
,      EVENT_ID
,      LEDGER_ID
,      ROW_ID
,      PACKET_ID
,      PERIOD_NAME
,      FUNDING_BUDGET_NAME
,      BUDGET_TYPE
,      BUDGET_VERSION_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      BUDGET_LEVEL
,      JE_BATCH_NAME
,      TREASURY_SYMBOL
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_HEADER_NAME
,      JOURNAL_LINE_NUMBER
,      CCID
,      USSGL_TRANSACTION_CODE
,      ACCOUNT_TYPE
,      ACCOUNT_TYPE_MEANING
,      ACCOUNT_CATEGORY_CODE
,      ACCOUNT_SEGMENT_VALUE
,      ACTUAL_FLAG
,      ACTUAL_FLAG_MEANING
,      AMOUNT_TYPE
,      AMOUNT_TYPE_MEANING
,      ENCUMBRANCE_TYPE
,      TEMPLATE_ID
,      CURRENCY_CODE
,      FUNDS_CHECK_STATUS_CODE
,      FUNDS_CHECK_STATUS
,      EFFECTIVE_STATUS
,      FUNDS_CHECK_LEVEL_CODE
,      FUNDS_CHECK_LEVEL_MEANING
,      RESULT_CODE
,      RESULT_MESSAGE
,      BOUNDARY_CODE
,      BOUNDARY
,      DEBIT_CREDIT_INDICATOR
,      AMOUNT
,      DEBIT_AMOUNT_ACCOUNTED
,      CREDIT_AMOUNT_ACCOUNTED
,      BUDGET_POSTED_BALANCE
,      BUDGET_APPROVED_BALANCE
,      BUDGET_PENDING_BALANCE
,      BUDGET_TOTAL_BALANCE
,      ENCUMBRANCE_POSTED_BALANCE
,      ENCUMBRANCE_APPROVED_BALANCE
,      ENCUMBRANCE_PENDING_BALANCE
,      ENCUMBRANCE_TOTAL_BALANCE
,      ACTUAL_POSTED_BALANCE
,      ACTUAL_APPROVED_BALANCE
,      ACTUAL_PENDING_BALANCE
,      ACTUAL_TOTAL_BALANCE
,      AVAILABLE_POSTED_BALANCE
,      AVAILABLE_APPROVED_BALANCE
,      AVAILABLE_PENDING_BALANCE
,      AVAILABLE_TOTAL_BALANCE
,      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
,      DOCUMENT_REFERENCE
,      LINE_REFERENCE
,      BATCH_REFERENCE
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      PARTY_ID
,      PARTY_SITE_ID
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      PAYMENT_FORECAST_LINE_NUMBER
,      PA_FLAG
,      ACCOUNTING_FLEXFIELD
,      SUMMARY_ACCOUNT_INDICATOR
,      PO_LINE_NUMBER
,      PO_DIST_LINE_NUMBER
,      PO_SHIP_LINE_NUMBER
,      REQ_LINE_NUMBER
,      REQ_DIST_LINE_NUMBER
,      INV_LINE_NUMBER
,      DOCUMENT_SEQUENCE_NUMBER
,      AE_HEADER_ID
,      AE_LINE_NUM
,      PERIOD_NUM
,      PERIOD_YEAR
,      QUARTER_NUM
,      COMM_ENCUM_POSTED_BAL
,      COMM_ENCUM_APPROVED_BAL
,      COMM_ENCUM_PENDING_BAL
,      COMM_ENCUM_TOTAL_BAL
,      OBLI_ENCUM_POSTED_BAL
,      OBLI_ENCUM_APPROVED_BAL
,      OBLI_ENCUM_PENDING_BAL
,      OBLI_ENCUM_TOTAL_BAL
,      ERROR_SOURCE
,      CURRENT_FUNDS_AVAILABLE
,      DOCUMENT_STATUS
FROM APPS.PSA_BC_RESULTS_GT;

Dependencies

[top of page]

APPS.PSA_BC_RESULTS_GT does not reference any database object

APPS.PSA_BC_RESULTS_GT is referenced by following:

APPS

PSA_BC_XML_REPORT_PUB - show dependent code