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

VIEW: AX.AX_SLE_HEADERS#

Object Details
Object Name: AX_SLE_HEADERS#
Object Type: VIEW
Owner: AX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOURNAL_SEQUENCE_ID NUMBER (15) Yes
SLE_HEADER_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SET_OF_BOOKS_ID NUMBER
Yes
APPLICATION_ID NUMBER
Yes
EVENT_ID NUMBER

EFFECTIVE_DATE DATE

PERIOD_NAME VARCHAR2 (15) Yes
CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
REFERENCE_1 VARCHAR2 (255)
REFERENCE_2 VARCHAR2 (255)
REFERENCE_3 VARCHAR2 (255)
REFERENCE_4 VARCHAR2 (255)
REFERENCE_5 VARCHAR2 (255)
ORG_ID NUMBER (15)
LEGAL_SEQUENCE_ID NUMBER (15)
LEGAL_SEQUENCE_VALUE NUMBER (15)
TRANSACTION_DATE DATE

REFERENCE_NUM1 NUMBER

REFERENCE_NUM2 NUMBER

REFERENCE_NUM3 NUMBER

REFERENCE_NUM4 NUMBER

REFERENCE_NUM5 NUMBER

REFERENCE_DATE1 DATE

REFERENCE_DATE2 DATE

REFERENCE_DATE3 DATE

REFERENCE_DATE4 DATE

REFERENCE_DATE5 DATE

DESCRIPTION VARCHAR2 (255)
DOC_SEQUENCE_ID NUMBER (15)
DOC_SEQUENCE_NUMBER NUMBER (15)
GL_TRANSFER_FLAG VARCHAR2 (1)
GL_TRANSFER_DATE DATE

GL_TRANSFER_RUN_ID NUMBER

GL_CATEGORY VARCHAR2 (30)
ACCOUNTING_SEQUENCE_ID NUMBER
Yes
Query Text

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


SELECT JOURNAL_SEQUENCE_ID
,      SLE_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SET_OF_BOOKS_ID
,      APPLICATION_ID
,      EVENT_ID
,      EFFECTIVE_DATE
,      PERIOD_NAME
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
,      ORG_ID
,      LEGAL_SEQUENCE_ID
,      LEGAL_SEQUENCE_VALUE
,      TRANSACTION_DATE
,      REFERENCE_NUM1
,      REFERENCE_NUM2
,      REFERENCE_NUM3
,      REFERENCE_NUM4
,      REFERENCE_NUM5
,      REFERENCE_DATE1
,      REFERENCE_DATE2
,      REFERENCE_DATE3
,      REFERENCE_DATE4
,      REFERENCE_DATE5
,      DESCRIPTION
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_NUMBER
,      GL_TRANSFER_FLAG
,      GL_TRANSFER_DATE
,      GL_TRANSFER_RUN_ID
,      GL_CATEGORY
,      ACCOUNTING_SEQUENCE_ID
FROM AX.AX_SLE_HEADERS#;

Dependencies

[top of page]

AX.AX_SLE_HEADERS# references the following:

SchemaAX
TableAX_SLE_HEADERS
AX.AX_SLE_HEADERS# is referenced by following:

SchemaAPPS
SynonymAX_SLE_HEADERS