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

VIEW: APPS.MSC_X_EXCEPTION_SEARCH_V

Object Details
Object Name: MSC_X_EXCEPTION_SEARCH_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

Plan identifier
SR_INSTANCE_ID NUMBER

Source application instance identifier
EXCEPTION_GROUP NUMBER

Exception group
EXCEPTION_GROUP_NAME VARCHAR2 (80)
Exception group name
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
COMPANY_SITE_ID NUMBER

Company site identifier
SUPPLIER_ID NUMBER

Supplier identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
CUSTOMER_ID NUMBER

Customer identifier
CUSTOMER_SITE_ID NUMBER

Customer site identifier
TRANSACTION_ID1 NUMBER

Transaction identifier 1
TRANSACTION_ID2 NUMBER

Transaction idenfitifier 2
TRANSACTION_ID3 NUMBER

Transaction identifier 3
VERSION VARCHAR2 (80)
Version
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
TRADING_PARTNER_ITEM_NAME VARCHAR2 (250)
Trading partner item name
COMPANY_SITE_NAME VARCHAR2 (40)
Company site name
CUSTOMER_NAME VARCHAR2 (255)
Customer name
CUSTOMER_SITE_NAME VARCHAR2 (40)
Customer site name
SUPPLIER_NAME VARCHAR2 (255)
Supplier name
SUPPLIER_SITE_NAME VARCHAR2 (40)
Supplier site name
ITEM_NAME VARCHAR2 (250)
Item name
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
CUSTOMER_ITEM_NAME VARCHAR2 (250)
Customer item name
SUPPLIER_ITEM_NAME VARCHAR2 (250)
Supplier item name
DATE1 DATE

Date 1
DATE2 DATE

Date 2
DATE3 DATE

Date 3
DATE4 DATE

Date 4
DATE5 DATE

Date 5
DATE6 DATE

Date 6
DATE7 DATE

Date 7
ORDER_CREATION_DATE1 DATE

Order creation date 1
ORDER_CREATION_DATE2 DATE

Order creation date 2
ITEM_MIN_QTY NUMBER

Item minimum quantity
ITEM_MAX_QTY NUMBER

Item maximum quantity
NUMBER1 NUMBER

Number 1
NUMBER2 NUMBER

Number 2
NUMBER3 NUMBER

Number 3
NUMBER4 NUMBER

Number 4
NUMBER5 NUMBER

Number 5
NUMBER6 NUMBER

Number 6
NUMBER7 NUMBER

Number 7
NUMBER8 NUMBER

Number 8
NUMBER9 NUMBER

Number 9
NUMBER10 NUMBER

Number 10
THRESHOLD NUMBER

Threshold
LEAD_TIME NUMBER

Lead time
ORDER_NUMBER VARCHAR2 (240)
Order number
LINE_NUMBER VARCHAR2 (20)
Line number
RELEASE_NUMBER VARCHAR2 (20)
Release number
END_ORDER_NUMBER VARCHAR2 (240)
Pegged order number
END_ORDER_LINE_NUMBER VARCHAR2 (20)
Pegged order line number
END_ORDER_REL_NUMBER VARCHAR2 (20)
Pegged order release number
DAYS_DIFFERENCE NUMBER

Days difference between Date2 and Date1
DAYS_PAST_DUE NUMBER

Date1 past due days
COMPRESSION_DAYS NUMBER

Days diff between order_creation_date1 and date1
QUANTITY_DIFFERENCE NUMBER

Diff between Number2 and Number1
VMI_SHORTAGE NUMBER

Vendor Managed Inventory shortage
VMI_EXCESS NUMBER

Vendor Managed Inventory excess
EXCEPTION_TYPE NUMBER

Exception type
EXCEPTION_DETAIL_ID NUMBER
Yes Exception detail Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
REPLENISHMENT_METHOD NUMBER

VMI Replenishment method
EXCEPTION_BASIS VARCHAR2 (100)
Basis for computing exceptions: Ship/Dock
EXCEPTION_TYPE_NAME VARCHAR2 (80)
Exception type name
OWNING_COMPANY_ID NUMBER

Owning company identifier
PLANNER_CODE VARCHAR2 (10)
Planner code (for reporting)
BUYER_NAME VARCHAR2 (240)
Name of buyer (for reporting)
Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      EXCEPTION_GROUP
,      EXCEPTION_GROUP_NAME
,      COMPANY_ID
,      COMPANY_NAME
,      COMPANY_SITE_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      TRANSACTION_ID1
,      TRANSACTION_ID2
,      TRANSACTION_ID3
,      VERSION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRADING_PARTNER_ITEM_NAME
,      COMPANY_SITE_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      ORDER_CREATION_DATE1
,      ORDER_CREATION_DATE2
,      ITEM_MIN_QTY
,      ITEM_MAX_QTY
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      THRESHOLD
,      LEAD_TIME
,      ORDER_NUMBER
,      LINE_NUMBER
,      RELEASE_NUMBER
,      END_ORDER_NUMBER
,      END_ORDER_LINE_NUMBER
,      END_ORDER_REL_NUMBER
,      DAYS_DIFFERENCE
,      DAYS_PAST_DUE
,      COMPRESSION_DAYS
,      QUANTITY_DIFFERENCE
,      VMI_SHORTAGE
,      VMI_EXCESS
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      INVENTORY_ITEM_ID
,      REPLENISHMENT_METHOD
,      EXCEPTION_BASIS
,      EXCEPTION_TYPE_NAME
,      OWNING_COMPANY_ID
,      PLANNER_CODE
,      BUYER_NAME
FROM APPS.MSC_X_EXCEPTION_SEARCH_V;

Dependencies

[top of page]

APPS.MSC_X_EXCEPTION_SEARCH_V references the following:

SchemaAPPS
SynonymMSC_COMPANY_SITES
SynonymMSC_SYSTEM_ITEMS
SynonymMSC_TRADING_PARTNERS
SynonymMSC_TRADING_PARTNER_MAPS
SynonymMSC_X_EXCEPTION_DETAILS

APPS.MSC_X_EXCEPTION_SEARCH_V is not referenced by any database object