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

VIEW: BIM.BIM_EDW_OPRNTIES_F#

Object Details
Object Name: BIM_EDW_OPRNTIES_F#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPPR_LINE_PK_KEY NUMBER

OPPR_LINE_PK VARCHAR2 (320)
CMPGN_FK_KEY NUMBER
Yes
CMPGN_STATUS_FK_KEY NUMBER
Yes
EVENT_FK_KEY NUMBER
Yes
MDCHNL_FK_KEY NUMBER
Yes
MKTSGMT_FK_KEY NUMBER
Yes
TGTSGMT_FK_KEY NUMBER
Yes
SRCLST_FK_KEY NUMBER
Yes
OFFER_FK_KEY NUMBER

OPPLINE_FK_KEY NUMBER
Yes
OPPSTATUS_FK_KEY NUMBER
Yes
CUSTOMER_FK_KEY NUMBER
Yes
TIME_FK_KEY NUMBER
Yes
ORG_FK_KEY NUMBER
Yes
ITEM_FK_KEY NUMBER
Yes
UOM_FK_KEY NUMBER
Yes
SLSCHNL_FK_KEY NUMBER
Yes
BASE_CURRENCY_FK_KEY NUMBER
Yes
GLOBAL_CURRENCY_FK_KEY NUMBER
Yes
TRX_CURRENCY_FK_KEY NUMBER
Yes
BILL_TO_SITE_FK_KEY NUMBER
Yes
SHIP_TO_SITE_FK_KEY NUMBER
Yes
INSTANCE_FK_KEY NUMBER
Yes
OPPR_AMOUNT_G NUMBER

OPPR_AMOUNT_B NUMBER

OPPR_AMOUNT_T NUMBER

OPPR_UNITS NUMBER

USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

USER_FK1_KEY NUMBER

USER_FK2_KEY NUMBER

USER_FK3_KEY NUMBER

USER_FK4_KEY NUMBER

USER_FK5_KEY NUMBER

USER_ATTRIBUTE1 VARCHAR2 (240)
USER_ATTRIBUTE2 VARCHAR2 (240)
USER_ATTRIBUTE3 VARCHAR2 (240)
USER_ATTRIBUTE4 VARCHAR2 (240)
USER_ATTRIBUTE5 VARCHAR2 (240)
USER_ATTRIBUTE6 VARCHAR2 (240)
USER_ATTRIBUTE7 VARCHAR2 (240)
USER_ATTRIBUTE8 VARCHAR2 (240)
USER_ATTRIBUTE9 VARCHAR2 (240)
USER_ATTRIBUTE10 VARCHAR2 (240)
USER_ATTRIBUTE11 VARCHAR2 (240)
USER_ATTRIBUTE12 VARCHAR2 (240)
USER_ATTRIBUTE13 VARCHAR2 (240)
USER_ATTRIBUTE14 VARCHAR2 (240)
USER_ATTRIBUTE15 VARCHAR2 (240)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT OPPR_LINE_PK_KEY
,      OPPR_LINE_PK
,      CMPGN_FK_KEY
,      CMPGN_STATUS_FK_KEY
,      EVENT_FK_KEY
,      MDCHNL_FK_KEY
,      MKTSGMT_FK_KEY
,      TGTSGMT_FK_KEY
,      SRCLST_FK_KEY
,      OFFER_FK_KEY
,      OPPLINE_FK_KEY
,      OPPSTATUS_FK_KEY
,      CUSTOMER_FK_KEY
,      TIME_FK_KEY
,      ORG_FK_KEY
,      ITEM_FK_KEY
,      UOM_FK_KEY
,      SLSCHNL_FK_KEY
,      BASE_CURRENCY_FK_KEY
,      GLOBAL_CURRENCY_FK_KEY
,      TRX_CURRENCY_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      INSTANCE_FK_KEY
,      OPPR_AMOUNT_G
,      OPPR_AMOUNT_B
,      OPPR_AMOUNT_T
,      OPPR_UNITS
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM BIM.BIM_EDW_OPRNTIES_F#;

Dependencies

[top of page]

BIM.BIM_EDW_OPRNTIES_F# references the following:

SchemaBIM
TableBIM_EDW_OPRNTIES_F
BIM.BIM_EDW_OPRNTIES_F# is referenced by following:

SchemaAPPS
SynonymBIM_EDW_OPRNTIES_F