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

VIEW: APPS.MST_CUSTOMER_DETAILS_V

Object Details
Object Name: MST_CUSTOMER_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.
CUSTOMER_ID NUMBER (15) Yes ID of Customer. FK to CUST_ACCOUNT_ID of HZ_CUST_ACCOUNTS.
CUSTOMER_NAME VARCHAR2 (360) Yes Customer Party name.
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan Name.
DESCRIPTION VARCHAR2 (50)
Plan Description.
LOAD_COUNT_STR VARCHAR2 (200)
String Containing Concatenated count of Direct TLs, Multi-stop TLs, LTLs and Parcels.
TOTAL_COST NUMBER

Cost Related to Customer.
TOTAL_WEIGHT NUMBER

Weight Related to Customer.
TOTAL_CUBE NUMBER

Cube Related to Customer.
TOTAL_PALLETS NUMBER

Pallets Related to Customer.
TOTAL_PIECES NUMBER

Pieces Related to Customer.
TOTAL_ORDERS NUMBER

Orders Related to Customer.
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
,      CUSTOMER_ID
,      CUSTOMER_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_CUSTOMER_DETAILS_V;

Dependencies

[top of page]

APPS.MST_CUSTOMER_DETAILS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_DELIVERIES
SynonymMST_PLANS
SynonymWSH_LOCATION_OWNERS

APPS.MST_CUSTOMER_DETAILS_V is not referenced by any database object