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

VIEW: APPS.BIM_SUMV_SLIST_PROFIT

Object Details
Object Name: BIM_SUMV_SLIST_PROFIT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_SUMV_SLIST_PROFIT
Subobject Name:
Status: VALID

View Type

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


BIM_SUMV_SLIST_PROFIT is a view that joins the summary table to the dimension views. It is used by the following reports: Source List Profitability.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_LIST_ID NUMBER
Yes source list id
SOURCE_LIST_NAME VARCHAR2 (120)
source list name
PERIOD_NAME VARCHAR2 (25) Yes period name
START_DATE DATE
Yes start date
END_DATE DATE
Yes end date
INITIATED_REVENUE NUMBER

initiated revenue
ACTUAL_COST NUMBER

actual cost
Query Text

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


SELECT SOURCE_LIST_ID
,      SOURCE_LIST_NAME
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      INITIATED_REVENUE
,      ACTUAL_COST
FROM APPS.BIM_SUMV_SLIST_PROFIT;

Dependencies

[top of page]

APPS.BIM_SUMV_SLIST_PROFIT references the following:

SchemaAPPS
ViewBIM_DIMV_SOURCE_LISTS
SynonymBIM_SLIST_PROFIT_SUMM
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_SLIST_PROFIT is not referenced by any database object