[Home] [Help] [Dependency Information]
Object Name: | JA_CN_SUBSIDIARY_GT |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.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 extract the subsidiary account info from interface table during the exporting process.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (150) | Yes | Natural account segment from the account flexfield |
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 |
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;
JA.JA_CN_SUBSIDIARY_GT does not reference any database object
JA.JA_CN_SUBSIDIARY_GT is referenced by following:
|
|
|