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

VIEW: APPS.FV_ALC_BUSINESS_ACTIVITY_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is used in 224 Process and in ALC parameter lov of 224 Process. It gives us all the ALC with Business Acitivity and GWA reporter category for all period defined for ALC in ALC form. It gives the null values in these fields if ALC is not defined in ALC form.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER

Ledger Identifier
AGENCY_LOCATION_CODE VARCHAR2 (30)
Agency Location Code
FV_ALC_ADDRESSES_ID NUMBER

ALC Address Identifier
BUSINESS_ACTIVITY_CODE VARCHAR2 (30)
Business Activity Code
ALC_GWA_CATEGORY_ID NUMBER

GWA Category Identifier
GWA_REPORTER_CATEGORY_CODE VARCHAR2 (30)
GWA Reporter Category
EFFECTIVE_START_DATE DATE

Start date for the particular GWA reporter category
EFFECTIVE_END_DATE DATE

End date for the particular GWA reporter category
PERIOD_NAME VARCHAR2 (15)
GL Period Name
Query Text

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


SELECT SET_OF_BOOKS_ID
,      AGENCY_LOCATION_CODE
,      FV_ALC_ADDRESSES_ID
,      BUSINESS_ACTIVITY_CODE
,      ALC_GWA_CATEGORY_ID
,      GWA_REPORTER_CATEGORY_CODE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PERIOD_NAME
FROM APPS.FV_ALC_BUSINESS_ACTIVITY_V;

Dependencies

[top of page]

APPS.FV_ALC_BUSINESS_ACTIVITY_V references the following:

SchemaAPPS
SynonymCE_BANK_ACCOUNTS
SynonymCE_BANK_ACCT_USES_ALL
SynonymFV_ALC_ADDRESSES_ALL
SynonymFV_ALC_GWA_CATEGORIES
SynonymFV_OPERATING_UNITS_ALL
ViewGL_LEDGERS_PUBLIC_V
SynonymGL_PERIODS
SchemaPUBLIC
SynonymDUAL
APPS.FV_ALC_BUSINESS_ACTIVITY_V is referenced by following:

SchemaAPPS
Package BodyFV_GOALS_224 - show dependent code
Package BodyFV_SF224_TRANSACTIONS - show dependent code