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

VIEW: APPS.OZF_XLA_ACC_HEADER_V

Object Details
Object Name: OZF_XLA_ACC_HEADER_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view


This view stores detailed information of each transaction for Accrual flow.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15)
Event Identifier
THIRD_PARTY_TYPE CHAR (1)
Third Party Type
CUST_ACCOUNT_ID NUMBER

Customer Account Identifier
BILL_TO_SITE_USE_ID NUMBER

Bill to Site Use Identifier
ACCRUAL_AMOUNT NUMBER

Accrual Amount
ACCRUAL_CURRENCY VARCHAR2 (15)
Accrual Amount
ACCRUAL_LEDGER_AMOUNT NUMBER

Accrual Ledger Amount
PAID_ADJ_AMOUNT NUMBER

Paid Adjustment Amount
PAID_ADJ_LEDGER_AMOUNT NUMBER

Paid Adjustment Ledger Amount
DISTRIBUTION_TYPE CHAR (7)
Distribution Type
DISTRIBUTION_ID NUMBER
Yes Distribution Identifier
PRODUCT_ID NUMBER

Product Identifier
INVENTORY_ORGANIZATION_ID VARCHAR2 (4000)
Inventory Organization Identifier
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ACTIVITY_CODE VARCHAR2 (240) Yes Activity Code
BUDGET_NAME VARCHAR2 (240) Yes Budget Name
BUDGET_NUMBER VARCHAR2 (30) Yes Budget Number
UTILIZATION_TYPE VARCHAR2 (30)
Utilization Type
ADJUSTMENT_TYPE VARCHAR2 (30)
Adjustment Type
ADJUSTMENT_TYPE_ID NUMBER

Adjustment Type Identifier
EXCHANGE_RATE NUMBER

Exchange Rate
EXCHANGE_RATE_DATE DATE

Exchange Rate Date
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Date
GL_DATE DATE

GL Date
OBJECT_TYPE VARCHAR2 (30)
Object Type
OBJECT_ID NUMBER

Object Identifier
ORDER_LINE_ID NUMBER

Order Line Identifier
PRICE_ADJUSTMENT_ID NUMBER

Price Adjustment ID
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
REFERENCE_ID NUMBER

Reference Identifier
SYS_PARAM_EXPENSE_ACCOUNT_CCID NUMBER

System Parameters Expense Account Code Combination Identifier
SYS_PARAM_LIABILITY_ACCT_CCID NUMBER

System Parameters Liability Account Code Combination Identifier
FUND_CATG_EXPENSE_ACCT_CCID NUMBER (15)
Fund Category Expense Account Code Combination Identifier
FUND_CATG_LIABILITY_ACCT_CCID NUMBER (15)
Fund Category Liability Account Code Combination Identifier
FUND_EXPENSE_ACCT_CCID NUMBER (15)
Fund Expense Account Code Combination Identifier
FUND_LIABILITY_ACCT_CCID NUMBER (15)
Fund Category Liability Account Code Combination Identifier
ADJ_EXPENSE_ACCT_CCID NUMBER

Adjustment Expense Account Code Combination Identifier
ADJ_LIABILITY_ACCT_CCID NUMBER

Adjustment Expense Account Code Combination Identifier
ADJUSTMENT_CR_ACCT_CCID NUMBER

Adjustment Credit Account Code Combination Identifier
ADJUSTMENT_DR_ACCT_CCID NUMBER

Adjustment Debit Account Code Combination Identifier
REVENUE_ACCT_CCID NUMBER

Revenue Account Code Combination Identifier
ACCOUNTED_AMOUNT_OVERRIDE_FLAG CHAR (1)
Accounted Amount Override Flag
ACTG_ACCRUAL_ACCT_CCID NUMBER

Account Generator Accrual Account
ACTG_EXPENSE_ACCT_CCID NUMBER

Account Generator Expense Account
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Attribute 15
Query Text

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


SELECT EVENT_ID
,      THIRD_PARTY_TYPE
,      CUST_ACCOUNT_ID
,      BILL_TO_SITE_USE_ID
,      ACCRUAL_AMOUNT
,      ACCRUAL_CURRENCY
,      ACCRUAL_LEDGER_AMOUNT
,      PAID_ADJ_AMOUNT
,      PAID_ADJ_LEDGER_AMOUNT
,      DISTRIBUTION_TYPE
,      DISTRIBUTION_ID
,      PRODUCT_ID
,      INVENTORY_ORGANIZATION_ID
,      ACTIVITY_TYPE
,      ACTIVITY_CODE
,      BUDGET_NAME
,      BUDGET_NUMBER
,      UTILIZATION_TYPE
,      ADJUSTMENT_TYPE
,      ADJUSTMENT_TYPE_ID
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      GL_DATE
,      OBJECT_TYPE
,      OBJECT_ID
,      ORDER_LINE_ID
,      PRICE_ADJUSTMENT_ID
,      REFERENCE_TYPE
,      REFERENCE_ID
,      SYS_PARAM_EXPENSE_ACCOUNT_CCID
,      SYS_PARAM_LIABILITY_ACCT_CCID
,      FUND_CATG_EXPENSE_ACCT_CCID
,      FUND_CATG_LIABILITY_ACCT_CCID
,      FUND_EXPENSE_ACCT_CCID
,      FUND_LIABILITY_ACCT_CCID
,      ADJ_EXPENSE_ACCT_CCID
,      ADJ_LIABILITY_ACCT_CCID
,      ADJUSTMENT_CR_ACCT_CCID
,      ADJUSTMENT_DR_ACCT_CCID
,      REVENUE_ACCT_CCID
,      ACCOUNTED_AMOUNT_OVERRIDE_FLAG
,      ACTG_ACCRUAL_ACCT_CCID
,      ACTG_EXPENSE_ACCT_CCID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.OZF_XLA_ACC_HEADER_V;

Dependencies

[top of page]

APPS.OZF_XLA_ACC_HEADER_V references the following:

SchemaAPPS
SynonymAMS_CATEGORIES_B
PL/SQL PackageFND_PROFILE - show dependent code
SynonymOZF_CLAIM_TYPES_ALL_B
ViewOZF_FUNDS_ALL_VL
SynonymOZF_FUNDS_UTILIZED_ALL_B
SynonymOZF_SYS_PARAMETERS_ALL
PL/SQL PackageOZF_UTILITY_PVT - show dependent code
SynonymOZF_XLA_ACCRUALS
ViewQP_LIST_HEADERS_ALL
SynonymXLA_EVENTS_GT

APPS.OZF_XLA_ACC_HEADER_V is not referenced by any database object