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

VIEW: APPS.FAFV_TRANS_LINES

Object Details
Object Name: FAFV_TRANS_LINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FAFV_TRANS_LINES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information needed to create journal entries for transactions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_TYPE VARCHAR2 (15) Yes Indicates the type of account this adjustment affects
DEBIT_AMOUNT NUMBER

CREDIT_AMOUNT NUMBER

TRANSACTION_HEADER_ID NUMBER (15) Yes
SOURCE_TYPE_CODE VARCHAR2 (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER (15) Yes
CODE_COMBINATION_ID NUMBER (15)
_KF:EXPENSE_ACCOUNT CHAR (17)
DISTRIBUTION_ID NUMBER (15)
PERIOD_COUNTER_ADJUSTED NUMBER (15) Yes
PERIOD_ADJUSTED VARCHAR2 (15) Yes
PERIOD_COUNTER_CREATED NUMBER (15) Yes
PERIOD_CREATED VARCHAR2 (15) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
Query Text

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


SELECT ADJUSTMENT_TYPE
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
,      TRANSACTION_HEADER_ID
,      SOURCE_TYPE_CODE
,      BOOK_TYPE_CODE
,      ASSET_ID
,      CODE_COMBINATION_ID
,      _KF:EXPENSE_ACCOUNT
,      DISTRIBUTION_ID
,      PERIOD_COUNTER_ADJUSTED
,      PERIOD_ADJUSTED
,      PERIOD_COUNTER_CREATED
,      PERIOD_CREATED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.FAFV_TRANS_LINES;

Dependencies

[top of page]

APPS.FAFV_TRANS_LINES references the following:

SchemaAPPS
SynonymFA_ADJUSTMENTS
SynonymFA_DEPRN_PERIODS
SynonymGL_CODE_COMBINATIONS
SynonymXLA_AE_LINES
SynonymXLA_DISTRIBUTION_LINKS

APPS.FAFV_TRANS_LINES is not referenced by any database object