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

VIEW: APPS.BIM_FCTV_OPPLINES

Object Details
Object Name: BIM_FCTV_OPPLINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_FCTV_OPPLINES
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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPPORTUNITY_LEAD_ID NUMBER
Yes
OPPORTUNITY_LEAD_LINE_ID NUMBER
Yes
CAMPAIGN_ID NUMBER

EVENT_HEADER_ID VARCHAR2 (80)
EVENT_OFFER_ID VARCHAR2 (80)
CHANNEL_ID VARCHAR2 (80)
MEDIA_ID NUMBER

MARKET_SEGMENT_ID NUMBER

TARGET_SEGMENT_ID NUMBER

SALES_CHANNEL_CODE VARCHAR2 (30)
INTEREST_TYPE_ID NUMBER

PRIMARY_INTEREST_CODE_ID NUMBER

SECONDARY_INTEREST_CODE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

CREATION_DATE DATE
Yes
GEOGRAPHY_CODE VARCHAR2 (246)
REVENUE_AMOUNT NUMBER

UNITS NUMBER

Query Text

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


SELECT OPPORTUNITY_LEAD_ID
,      OPPORTUNITY_LEAD_LINE_ID
,      CAMPAIGN_ID
,      EVENT_HEADER_ID
,      EVENT_OFFER_ID
,      CHANNEL_ID
,      MEDIA_ID
,      MARKET_SEGMENT_ID
,      TARGET_SEGMENT_ID
,      SALES_CHANNEL_CODE
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      INVENTORY_ITEM_ID
,      CREATION_DATE
,      GEOGRAPHY_CODE
,      REVENUE_AMOUNT
,      UNITS
FROM APPS.BIM_FCTV_OPPLINES;

Dependencies

[top of page]

APPS.BIM_FCTV_OPPLINES references the following:

SchemaAPPS
SynonymAMS_PARTY_MARKET_SEGMENTS
SynonymAS_LEADS_ALL
SynonymAS_LEAD_LINES_ALL
SynonymBIM_SOURCE_CODE_DETAILS
PL/SQL PackageBIM_TARGET_SEGMENT_PKG - show dependent code
SynonymHZ_LOCATIONS

APPS.BIM_FCTV_OPPLINES is not referenced by any database object