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

VIEW: APPS.CSP_MINMAX_NOTIFS_V

Object Details
Object Name: CSP_MINMAX_NOTIFS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_MINMAX_NOTIFS_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
NOTIFICATION_ID NUMBER (35) Yes
ORGANIZATION_ID NUMBER (35)
INVENTORY_ITEM_ID NUMBER (35) Yes
ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_COST NUMBER

Item Cost
PLANNER_CODE VARCHAR2 (10)
NOTIFICATION_TYPE VARCHAR2 (30)
NOTIFICATION_TYPE_MEANING VARCHAR2 (80) Yes
NOTIFICATION_QTY NUMBER (35)
NOTIFICATION_DATE DATE
Yes
EXCESS_QTY NUMBER

REPAIR_QTY NUMBER

NEED_DATE DATE

ORDER_BY_DATE DATE

Order by date
STATUS VARCHAR2 (30) Yes Notification status
STATUS_DESC VARCHAR2 (80) Yes Notification status meaning
Query Text

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


SELECT NOTIFICATION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_COST
,      PLANNER_CODE
,      NOTIFICATION_TYPE
,      NOTIFICATION_TYPE_MEANING
,      NOTIFICATION_QTY
,      NOTIFICATION_DATE
,      EXCESS_QTY
,      REPAIR_QTY
,      NEED_DATE
,      ORDER_BY_DATE
,      STATUS
,      STATUS_DESC
FROM APPS.CSP_MINMAX_NOTIFS_V;

Dependencies

[top of page]

APPS.CSP_MINMAX_NOTIFS_V references the following:

SchemaAPPS
SynonymCSP_NOTIFICATIONS
SynonymCSP_NOTIFICATION_DETAILS
ViewCST_ITEM_COSTS_FOR_GL_VIEW
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CSP_MINMAX_NOTIFS_V is not referenced by any database object