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

VIEW: APPS.MST_SUPPLIER_DETAILS_V

Object Details
Object Name: MST_SUPPLIER_DETAILS_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
Yes FK to PLAN_ID of MST_PLANS
SUPPLIER_ID NUMBER
Yes ID of Supplier.
SUPPLIER_NAME VARCHAR2 (240)
Name of Supplier.
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan name
DESCRIPTION VARCHAR2 (50)
Plan description.
LOAD_COUNT_STR VARCHAR2 (200)
String with concatenated count of trips (Direct TL, Multi-stop TL, LTL, Parcel).
TOTAL_COST NUMBER

Total Cost related to Supplier.
TOTAL_WEIGHT NUMBER

Weight related to Supplier.
TOTAL_CUBE NUMBER

Cube related to Supplier.
TOTAL_PALLETS NUMBER

Pallets related to Supplier.
TOTAL_PIECES NUMBER

Pieces related to Supplier.
TOTAL_ORDERS NUMBER

Orders related to Supplier.
CURRENCY_UOM VARCHAR2 (3)
Unit of Measure for Cost.
WEIGHT_UOM VARCHAR2 (3)
Unit of Measure for Weight.
VOLUME_UOM VARCHAR2 (3)
Unit of Measure for Volume.
Query Text

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


SELECT PLAN_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      LOAD_COUNT_STR
,      TOTAL_COST
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_SUPPLIER_DETAILS_V;

Dependencies

[top of page]

APPS.MST_SUPPLIER_DETAILS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_DELIVERY_DETAILS
SynonymMST_PLANS
ViewPO_VENDORS
SynonymWSH_LOCATIONS
SynonymWSH_LOCATION_OWNERS

APPS.MST_SUPPLIER_DETAILS_V is not referenced by any database object