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

VIEW: JL.JL_CO_FA_ADJUSTMENTS#

Object Details
Object Name: JL_CO_FA_ADJUSTMENTS#
Object Type: VIEW
Owner: JL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_HEADER_ID NUMBER (15)
SOURCE_TYPE_CODE VARCHAR2 (15) Yes
JE_CATEGORY_NAME VARCHAR2 (25) Yes
ADJUSTMENT_TYPE VARCHAR2 (15) Yes
DEBIT_CREDIT_FLAG VARCHAR2 (2) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER (15) Yes
ADJUSTMENT_AMOUNT NUMBER
Yes
DISTRIBUTION_ID NUMBER (15)
ANNUALIZED_ADJUSTMENT NUMBER

JE_HEADER_REFERENCE_ID NUMBER (15)
SEQUENCE_LINE NUMBER (15)
PERIOD_COUNTER_ADJUSTED NUMBER (15) Yes
PERIOD_COUNTER_CREATED NUMBER (15) Yes
ASSET_INVOICE_ID NUMBER (15)
REFERENCE VARCHAR2 (150)
POSTING_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT TRANSACTION_HEADER_ID
,      SOURCE_TYPE_CODE
,      JE_CATEGORY_NAME
,      ADJUSTMENT_TYPE
,      DEBIT_CREDIT_FLAG
,      CODE_COMBINATION_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      ADJUSTMENT_AMOUNT
,      DISTRIBUTION_ID
,      ANNUALIZED_ADJUSTMENT
,      JE_HEADER_REFERENCE_ID
,      SEQUENCE_LINE
,      PERIOD_COUNTER_ADJUSTED
,      PERIOD_COUNTER_CREATED
,      ASSET_INVOICE_ID
,      REFERENCE
,      POSTING_FLAG
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM JL.JL_CO_FA_ADJUSTMENTS#;

Dependencies

[top of page]

JL.JL_CO_FA_ADJUSTMENTS# references the following:

SchemaJL
TableJL_CO_FA_ADJUSTMENTS
JL.JL_CO_FA_ADJUSTMENTS# is referenced by following:

SchemaAPPS
SynonymJL_CO_FA_ADJUSTMENTS