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

TABLE: AP.JG_ZZ_AP_TMP_ACCOUNT

Object Details
Object Name: JG_ZZ_AP_TMP_ACCOUNT
Object Type: TABLE
Owner: AP
FND Design Data: TableJG.JG_ZZ_AP_TMP_ACCOUNT
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JG_ZZ_AP_TMP_ACCOUNT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNTING_EVENT_ID
JG_ZZ_AP_TMP_ACCOUNT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
AE_LINE_ID NUMBER (15)
ACCOUNTING_EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LINE_TYPE_FIELD VARCHAR2 (25)
TAX_CODE_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
ACCT_FLEX_FIELD VARCHAR2 (240)
ACCT_FLEX_DESC VARCHAR2 (240)
BALANCE VARCHAR2 (25)
BALANCE_DESC VARCHAR2 (240)
ACCOUNT VARCHAR2 (25)
ACCOUNT_DESC VARCHAR2 (240)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT REQUEST_ID
,      AE_LINE_ID
,      ACCOUNTING_EVENT_ID
,      LINE_NUMBER
,      LINE_TYPE_FIELD
,      TAX_CODE_ID
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      ACCT_FLEX_FIELD
,      ACCT_FLEX_DESC
,      BALANCE
,      BALANCE_DESC
,      ACCOUNT
,      ACCOUNT_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AP.JG_ZZ_AP_TMP_ACCOUNT;

Dependencies

[top of page]

AP.JG_ZZ_AP_TMP_ACCOUNT does not reference any database object

AP.JG_ZZ_AP_TMP_ACCOUNT is referenced by following:

SchemaAPPS
SynonymJG_ZZ_AP_TMP_ACCOUNT