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

VIEW: APPS.ARBV_ADJUSTMENT_DISTRIBUTIONS

Object Details
Object Name: ARBV_ADJUSTMENT_DISTRIBUTIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.ARBV_ADJUSTMENT_DISTRIBUTIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about adjustment amounts posted to the General Ledger.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_ID NUMBER (15) Yes
_LA:ACCOUNT_TYPE CHAR (41)
DEBIT_AMOUNT NUMBER

CREDIT_AMOUNT NUMBER

FUNCTIONAL_DEBIT_AMOUNT NUMBER

FUNCTIONAL_CREDIT_AMOUNT NUMBER

GENERAL_LEDGER_DATE DATE
Yes
_LA:POSTED_FLAG CHAR (86)
CODE_COMBINATION_ID NUMBER (15)
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Yes
PAYMENT_SCHEDULE_ID NUMBER (15)
TRANSACTION_ID NUMBER (15)
ADJUSTMENT_DATE DATE

_LA:ADJUSTMENT_REASON CHAR (52)
ADJUSTMENT_STATUS_CODE VARCHAR2 (30) Yes
Query Text

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


SELECT ADJUSTMENT_ID
,      _LA:ACCOUNT_TYPE
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
,      FUNCTIONAL_DEBIT_AMOUNT
,      FUNCTIONAL_CREDIT_AMOUNT
,      GENERAL_LEDGER_DATE
,      _LA:POSTED_FLAG
,      CODE_COMBINATION_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      SET_OF_BOOKS_ID
,      PAYMENT_SCHEDULE_ID
,      TRANSACTION_ID
,      ADJUSTMENT_DATE
,      _LA:ADJUSTMENT_REASON
,      ADJUSTMENT_STATUS_CODE
FROM APPS.ARBV_ADJUSTMENT_DISTRIBUTIONS;

Dependencies

[top of page]

APPS.ARBV_ADJUSTMENT_DISTRIBUTIONS references the following:

SchemaAPPS
SynonymAR_ADJUSTMENTS
ViewAR_XLA_ARD_LINES_V
SynonymXLA_AE_HEADERS

APPS.ARBV_ADJUSTMENT_DISTRIBUTIONS is not referenced by any database object