[Home] [Help] [Dependency Information]
Object Name: | PSA_BC_RESULTS_GT |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | PSA.PSA_BC_RESULTS_GT |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | ||
APPLICATION_SHORT_NAME | VARCHAR2 | (50) | ||
APPLICATION_NAME | VARCHAR2 | (240) | ||
EVENT_ID | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
ROW_ID | VARCHAR2 | (30) | ||
PACKET_ID | NUMBER | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
FUNDING_BUDGET_NAME | VARCHAR2 | (15) | ||
BUDGET_TYPE | VARCHAR2 | (15) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
JE_SOURCE_NAME | VARCHAR2 | (25) | ||
JE_CATEGORY_NAME | VARCHAR2 | (25) | ||
BUDGET_LEVEL | VARCHAR2 | (25) | ||
JE_BATCH_NAME | VARCHAR2 | (100) | ||
TREASURY_SYMBOL | VARCHAR2 | (100) | ||
JE_BATCH_ID | NUMBER | (15) | ||
JE_HEADER_ID | NUMBER | (15) | ||
JE_HEADER_NAME | VARCHAR2 | (100) | ||
JOURNAL_LINE_NUMBER | VARCHAR2 | (15) | ||
CCID | NUMBER | (15) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
ACCOUNT_TYPE_MEANING | VARCHAR2 | (240) | ||
ACCOUNT_CATEGORY_CODE | VARCHAR2 | (1) | ||
ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | ||
ACTUAL_FLAG_MEANING | VARCHAR2 | (240) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
AMOUNT_TYPE_MEANING | VARCHAR2 | (25) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
TEMPLATE_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
FUNDS_CHECK_STATUS_CODE | VARCHAR2 | (1) | ||
FUNDS_CHECK_STATUS | VARCHAR2 | (80) | ||
EFFECTIVE_STATUS | VARCHAR2 | (1) | ||
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | ||
FUNDS_CHECK_LEVEL_MEANING | VARCHAR2 | (25) | ||
RESULT_CODE | VARCHAR2 | (3) | ||
RESULT_MESSAGE | VARCHAR2 | (2000) | ||
BOUNDARY_CODE | VARCHAR2 | (1) | ||
BOUNDARY | VARCHAR2 | (25) | ||
DEBIT_CREDIT_INDICATOR | VARCHAR2 | (1) | ||
AMOUNT | NUMBER | |||
DEBIT_AMOUNT_ACCOUNTED | NUMBER | |||
CREDIT_AMOUNT_ACCOUNTED | NUMBER | |||
BUDGET_POSTED_BALANCE | NUMBER | |||
BUDGET_APPROVED_BALANCE | NUMBER | |||
BUDGET_PENDING_BALANCE | NUMBER | |||
BUDGET_TOTAL_BALANCE | NUMBER | |||
ENCUMBRANCE_POSTED_BALANCE | NUMBER | |||
ENCUMBRANCE_APPROVED_BALANCE | NUMBER | |||
ENCUMBRANCE_PENDING_BALANCE | NUMBER | |||
ENCUMBRANCE_TOTAL_BALANCE | NUMBER | |||
ACTUAL_POSTED_BALANCE | NUMBER | |||
ACTUAL_APPROVED_BALANCE | NUMBER | |||
ACTUAL_PENDING_BALANCE | NUMBER | |||
ACTUAL_TOTAL_BALANCE | NUMBER | |||
AVAILABLE_POSTED_BALANCE | NUMBER | |||
AVAILABLE_APPROVED_BALANCE | NUMBER | |||
AVAILABLE_PENDING_BALANCE | NUMBER | |||
AVAILABLE_TOTAL_BALANCE | NUMBER | |||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (38) | ||
DOCUMENT_REFERENCE | VARCHAR2 | (240) | ||
LINE_REFERENCE | VARCHAR2 | (240) | ||
BATCH_REFERENCE | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
PARTY_ID | VARCHAR2 | (100) | ||
PARTY_SITE_ID | VARCHAR2 | (100) | ||
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_SITE_NAME | VARCHAR2 | (15) | ||
PAYMENT_FORECAST_LINE_NUMBER | VARCHAR2 | (15) | ||
PA_FLAG | VARCHAR2 | (1) | ||
ACCOUNTING_FLEXFIELD | VARCHAR2 | (2000) | ||
SUMMARY_ACCOUNT_INDICATOR | VARCHAR2 | (1) | ||
PO_LINE_NUMBER | NUMBER | |||
PO_DIST_LINE_NUMBER | NUMBER | |||
PO_SHIP_LINE_NUMBER | NUMBER | |||
REQ_LINE_NUMBER | NUMBER | |||
REQ_DIST_LINE_NUMBER | NUMBER | |||
INV_LINE_NUMBER | VARCHAR2 | (15) | ||
DOCUMENT_SEQUENCE_NUMBER | NUMBER | |||
AE_HEADER_ID | NUMBER | |||
AE_LINE_NUM | NUMBER | |||
PERIOD_NUM | NUMBER | |||
PERIOD_YEAR | NUMBER | |||
QUARTER_NUM | NUMBER | |||
COMM_ENCUM_POSTED_BAL | NUMBER | |||
COMM_ENCUM_APPROVED_BAL | NUMBER | |||
COMM_ENCUM_PENDING_BAL | NUMBER | |||
COMM_ENCUM_TOTAL_BAL | NUMBER | |||
OBLI_ENCUM_POSTED_BAL | NUMBER | |||
OBLI_ENCUM_APPROVED_BAL | NUMBER | |||
OBLI_ENCUM_PENDING_BAL | NUMBER | |||
OBLI_ENCUM_TOTAL_BAL | NUMBER | |||
ERROR_SOURCE | VARCHAR2 | (1) | ||
CURRENT_FUNDS_AVAILABLE | NUMBER | |||
DOCUMENT_STATUS | VARCHAR2 | (240) |
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;
APPS.PSA_BC_RESULTS_GT does not reference any database object
APPS.PSA_BC_RESULTS_GT is referenced by following:
|
|
|