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

TABLE: JA.JAI_ST_INVOICE_REVERSAL_GT

Object Details
Object Name: JAI_ST_INVOICE_REVERSAL_GT
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_ST_INVOICE_REVERSAL_GT
Subobject Name:
Status: VALID

Temporary Table Details

JA.JAI_ST_INVOICE_REVERSAL_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$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
SERIAL_NUM NUMBER

INVOICE_NUM VARCHAR2 (50)
LINE_NUMBER NUMBER

CUSTOMER_TRX_LINE_ID NUMBER

ACCOUNTING_DATE DATE

ORIGINAL_LINE_AMT NUMBER

RCV_SVC_TAX NUMBER

OPEN_AMT NUMBER

TAX_TO_BE_ADJUSTED NUMBER

DATE_OF_REVERSAL DATE

AUTHORIZATION_DETAILS VARCHAR2 (240)
AUTHORIZATION_DATE DATE

REMARKS VARCHAR2 (150)
SOURCE VARCHAR2 (50)
INVOICE_ID NUMBER

MATCH_TYPE VARCHAR2 (30)
PARTY_ID NUMBER

PARTY_SITE_ID NUMBER

Query Text

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


SELECT SERIAL_NUM
,      INVOICE_NUM
,      LINE_NUMBER
,      CUSTOMER_TRX_LINE_ID
,      ACCOUNTING_DATE
,      ORIGINAL_LINE_AMT
,      RCV_SVC_TAX
,      OPEN_AMT
,      TAX_TO_BE_ADJUSTED
,      DATE_OF_REVERSAL
,      AUTHORIZATION_DETAILS
,      AUTHORIZATION_DATE
,      REMARKS
,      SOURCE
,      INVOICE_ID
,      MATCH_TYPE
,      PARTY_ID
,      PARTY_SITE_ID
FROM JA.JAI_ST_INVOICE_REVERSAL_GT;

Dependencies

[top of page]

JA.JAI_ST_INVOICE_REVERSAL_GT does not reference any database object

JA.JAI_ST_INVOICE_REVERSAL_GT is referenced by following:

SchemaAPPS
SynonymJAI_ST_INVOICE_REVERSAL_GT