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


VIEW: BEN.BEN_ACTL_PREM_F_EFC#

Object Details
Object Name: BEN_ACTL_PREM_F_EFC#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTL_PREM_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
EFC_ACTION_ID NUMBER (15) Yes
UPR_LMT_VAL NUMBER

LWR_LMT_VAL NUMBER

UOM VARCHAR2 (30)
VAL NUMBER

Query Text

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


SELECT ACTL_PREM_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EFC_ACTION_ID
,      UPR_LMT_VAL
,      LWR_LMT_VAL
,      UOM
,      VAL
FROM BEN.BEN_ACTL_PREM_F_EFC#;

Dependencies

[top of page]

BEN.BEN_ACTL_PREM_F_EFC# references the following:

SchemaBEN
TableBEN_ACTL_PREM_F_EFC
BEN.BEN_ACTL_PREM_F_EFC# is referenced by following:

SchemaAPPS
SynonymBEN_ACTL_PREM_F_EFC