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


VIEW: BEN.BEN_CVG_AMT_CALC_MTHD_F_EFC#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CVG_AMT_CALC_MTHD_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
EFC_ACTION_ID NUMBER (15) Yes
INCRMT_VAL NUMBER

MX_VAL NUMBER

MN_VAL NUMBER

DFLT_VAL NUMBER

LWR_LMT_VAL NUMBER

UPR_LMT_VAL NUMBER

PGM_UOM VARCHAR2 (30)
NIP_PL_UOM VARCHAR2 (30)
VAL NUMBER

Query Text

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


SELECT CVG_AMT_CALC_MTHD_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EFC_ACTION_ID
,      INCRMT_VAL
,      MX_VAL
,      MN_VAL
,      DFLT_VAL
,      LWR_LMT_VAL
,      UPR_LMT_VAL
,      PGM_UOM
,      NIP_PL_UOM
,      VAL
FROM BEN.BEN_CVG_AMT_CALC_MTHD_F_EFC#;

Dependencies

[top of page]

BEN.BEN_CVG_AMT_CALC_MTHD_F_EFC# references the following:

SchemaBEN
TableBEN_CVG_AMT_CALC_MTHD_F_EFC
BEN.BEN_CVG_AMT_CALC_MTHD_F_EFC# is referenced by following:

SchemaAPPS
SynonymBEN_CVG_AMT_CALC_MTHD_F_EFC