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

VIEW: APPS.SO_ORDER_HOLDS_VIEW_HOLD_V

Object Details
Object Name: SO_ORDER_HOLDS_VIEW_HOLD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOE.SO_ORDER_HOLDS_VIEW_HOLD_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_HOLD_ID NUMBER
Yes
NAME VARCHAR2 (30)

CRITERIA VARCHAR2 (40)

HOLD_LEVEL VARCHAR2 (40)

ACTION VARCHAR2 (35)

HOLD_UNTIL_DATE DATE


RELEASE_DATE DATE


RELEASER VARCHAR2 (100)

LINE_ID NUMBER


HOLD_SOURCE_ID NUMBER
Yes
HOLD_ENTITY_CODE VARCHAR2 (30)

HOLD_ENTITY_ID NUMBER


HEADER_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

ROW_ID ROWID (10)
Query Text

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


SELECT ORDER_HOLD_ID
,      NAME
,      CRITERIA
,      HOLD_LEVEL
,      ACTION
,      HOLD_UNTIL_DATE
,      RELEASE_DATE
,      RELEASER
,      LINE_ID
,      HOLD_SOURCE_ID
,      HOLD_ENTITY_CODE
,      HOLD_ENTITY_ID
,      HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ROW_ID
FROM APPS.SO_ORDER_HOLDS_VIEW_HOLD_V;

Dependencies

[top of page]

APPS.SO_ORDER_HOLDS_VIEW_HOLD_V references the following:

SchemaAPPS
SynonymFND_USER
SynonymSO_ACTIONS
SynonymSO_ENTITIES
SynonymSO_HOLDS
SynonymSO_HOLD_RELEASES
ViewSO_HOLD_SOURCES
SynonymSO_ORDER_HOLDS

APPS.SO_ORDER_HOLDS_VIEW_HOLD_V is not referenced by any database object