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

TABLE: JA.JA_CN_SUBSIDIARY_GT

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

JA_CN_SUBSIDIARY_GT is a session level global temporary table which stores subsidiary info for each natural account. These data will be used to help this program to extract the subsidiary account info from interface table during the exporting process.

Temporary Table Details

JA.JA_CN_SUBSIDIARY_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
ACCOUNT_SEGMENT_VALUE VARCHAR2 (150) Yes Nature account number
HAS_THIRD_PARTY VARCHAR2 (240)
'S'or 'C' indicates whether this natural account has third party subsidiary of supplier or customer.
HAS_COST_CENTER VARCHAR2 (240)
'Y'or 'N' indicates whether this natural account has cost center subsidiary.
HAS_PERSONNEL VARCHAR2 (240)
'Y'or 'N' indicates whether this natural account has personnel subsidiary.
HAS_PROJECT VARCHAR2 (240)
'Y'or 'N' indicates whether this natural account has project subsidiary.
IS_FOREIGN VARCHAR2 (240)
Foreign currency code is the account is foreign currency enabled
BALANCE_SIDE VARCHAR2 (240)
Account Balance side
ACCOUNT_LEVEL VARCHAR2 (240)
Account level
Query Text

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


SELECT ACCOUNT_SEGMENT_VALUE
,      HAS_THIRD_PARTY
,      HAS_COST_CENTER
,      HAS_PERSONNEL
,      HAS_PROJECT
,      IS_FOREIGN
,      BALANCE_SIDE
,      ACCOUNT_LEVEL
FROM JA.JA_CN_SUBSIDIARY_GT;

Dependencies

[top of page]

JA.JA_CN_SUBSIDIARY_GT does not reference any database object

JA.JA_CN_SUBSIDIARY_GT is referenced by following:

SchemaAPPS
SynonymJA_CN_SUBSIDIARY_GT