[Home] [Help] [Dependency Information]
Object Name: | FV_ALC_BUSINESS_ACTIVITY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|