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

VIEW: APPS.OEFV_HOLD_REASONS

Object Details
Object Name: OEFV_HOLD_REASONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OEFV_HOLD_REASONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows the types of holds that can be applied. You must define these hold reasons (holds) before you can create any specific order hold or hold source.


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240) Yes
_LA:HOLD_TYPE CHAR (42)
DESCRIPTION VARCHAR2 (2000)
START_DATE DATE

END_DATE DATE

_DF CHAR (32)
HOLD_ID NUMBER
Yes
ITEM_TYPE VARCHAR2 (8)
ACTIVITY_NAME VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT NAME
,      _LA:HOLD_TYPE
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      _DF
,      HOLD_ID
,      ITEM_TYPE
,      ACTIVITY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.OEFV_HOLD_REASONS;

Dependencies

[top of page]

APPS.OEFV_HOLD_REASONS references the following:

SchemaAPPS
SynonymOE_HOLD_DEFINITIONS

APPS.OEFV_HOLD_REASONS is not referenced by any database object