[Home] [Help] [Dependency Information]
Object Name: | MST_R_MASTER_ORDER_DET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Primary Key | ||
REPORT_FLAVOR | VARCHAR2 | (8) | 'FACILITY' -> Facility flavor; 'NORMAL' -> The other flavors of the report | |
OWNER_TYPE | NUMBER | Facility owner type | ||
FACILITY_ID | NUMBER | Facility ID | ||
CUSTOMER_ID | NUMBER | Customer ID | ||
SUPPLIER_ID | NUMBER | Supplier ID | ||
ORDER_TYPE | VARCHAR2 | (240) | Source type of the reference order SO, PO, etc. | |
HOST_COMP_ORDER_REF | VARCHAR2 | (50) | Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return line | |
SUPP_CUST_ORDER_REF | VARCHAR2 | (150) | The user visible identifier for the header, ex. Order number | |
ORDER_PIECES | NUMBER | Total number of pieces | ||
ORDER_WEIGHT | NUMBER | Gross weight | ||
ORDER_CUBE | NUMBER | Total volume | ||
ORDER_EARL_ALLOW_DATE | VARCHAR2 | (20) | Earliest Accepatable Date | |
ORDER_LATEST_ALLOW_DATE | VARCHAR2 | (20) | Latest Accpetable Date | |
ORDER_TOTAL_TRAN_COST | NUMBER | Total Transport Cost | ||
DEL_ID | NUMBER | Deliver ID | ||
SUBSHIPMENT_ID | NUMBER | |||
DEL_ORIGIN_LOC_CODE | VARCHAR2 | (10) | Delivery Origin Location Code | |
DEL_ORIGIN_LOC_NAME | VARCHAR2 | (80) | Delivery Origin Location name | |
DEL_ORIGIN_LOC_CITY | VARCHAR2 | (120) | Delivery Origin Location city | |
DEL_ORIGIN_LOC_STATE | VARCHAR2 | (120) | Delivery Origin Location state | |
DEL_ORIGIN_LOC_ZIP | VARCHAR2 | (60) | Delivery Origin Location postal code | |
DEL_DEST_LOC_CODE | VARCHAR2 | (10) | Delivery Destination Location code | |
DEL_DEST_LOC_NAME | VARCHAR2 | (80) | Delivery Destination Location name | |
DEL_DEST_LOC_CITY | VARCHAR2 | (120) | Delivery Destination Location city | |
DEL_DEST_LOC_STATE | VARCHAR2 | (120) | Delivery Destination Location state | |
DEL_DEST_LOC_ZIP | VARCHAR2 | (60) | Delivery Destination Location postal code | |
DEL_PIECES | NUMBER | Total number of pieces in the delivery | ||
DEL_WEIGHT | NUMBER | Gross weight of the delivery | ||
DEL_CUBE | NUMBER | Delivery Volume | ||
DEL_DEPART_DATE | VARCHAR2 | (40) | Delivery Departure Date | |
DEL_ARR_DATE | VARCHAR2 | (40) | Delivery Arrival Date | |
DEL_COST | NUMBER | Cost allocated to this delivery | ||
LEG_SEQ_NUM | NUMBER | |||
LEG_ID | NUMBER | Delviery Leg ID | ||
LEG_MODE_OF_TRANS | VARCHAR2 | (80) | TL / LTL / Parcel | |
LEG_CARRIER | VARCHAR2 | (30) | Carrier Name | |
LEG_BOL | NUMBER | Trip Number | ||
LEG_TL_STOP_SEQ_NUM_ORIG | NUMBER | |||
LEG_TL_STOP_SEQ_NUM_DEST | NUMBER | |||
LEG_ORIGIN_NAME | VARCHAR2 | (80) | Delivery Leg Origin name | |
LEG_ORIGIN_POOL_FLAG | VARCHAR2 | (4000) | Delivery Leg Origin is pooling location or not | |
LEG_ORIGIN_CITY | VARCHAR2 | (120) | Delivery Leg Origin city | |
LEG_ORIGIN_STATE | VARCHAR2 | (120) | Delivery Leg Origin state | |
LEG_DEST_NAME | VARCHAR2 | (80) | Delivery Leg Destination name | |
LEG_DEST_POOL_FLAG | VARCHAR2 | (4000) | Delivery Leg Destination is pooling location or not | |
LEG_DEST_CITY | VARCHAR2 | (120) | Delivery Leg Destination city | |
LEG_DEST_STATE | VARCHAR2 | (120) | Delivery Leg Destination state | |
LEG_DEPART_DATE | VARCHAR2 | (20) | Departure Date | |
LEG_ARR_DATE | VARCHAR2 | (20) | Arrival Date | |
LEG_TRANS_COST | NUMBER | Transportation cost allocated to this delivery leg |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, REPORT_FLAVOR
, OWNER_TYPE
, FACILITY_ID
, CUSTOMER_ID
, SUPPLIER_ID
, ORDER_TYPE
, HOST_COMP_ORDER_REF
, SUPP_CUST_ORDER_REF
, ORDER_PIECES
, ORDER_WEIGHT
, ORDER_CUBE
, ORDER_EARL_ALLOW_DATE
, ORDER_LATEST_ALLOW_DATE
, ORDER_TOTAL_TRAN_COST
, DEL_ID
, SUBSHIPMENT_ID
, DEL_ORIGIN_LOC_CODE
, DEL_ORIGIN_LOC_NAME
, DEL_ORIGIN_LOC_CITY
, DEL_ORIGIN_LOC_STATE
, DEL_ORIGIN_LOC_ZIP
, DEL_DEST_LOC_CODE
, DEL_DEST_LOC_NAME
, DEL_DEST_LOC_CITY
, DEL_DEST_LOC_STATE
, DEL_DEST_LOC_ZIP
, DEL_PIECES
, DEL_WEIGHT
, DEL_CUBE
, DEL_DEPART_DATE
, DEL_ARR_DATE
, DEL_COST
, LEG_SEQ_NUM
, LEG_ID
, LEG_MODE_OF_TRANS
, LEG_CARRIER
, LEG_BOL
, LEG_TL_STOP_SEQ_NUM_ORIG
, LEG_TL_STOP_SEQ_NUM_DEST
, LEG_ORIGIN_NAME
, LEG_ORIGIN_POOL_FLAG
, LEG_ORIGIN_CITY
, LEG_ORIGIN_STATE
, LEG_DEST_NAME
, LEG_DEST_POOL_FLAG
, LEG_DEST_CITY
, LEG_DEST_STATE
, LEG_DEPART_DATE
, LEG_ARR_DATE
, LEG_TRANS_COST
FROM APPS.MST_R_MASTER_ORDER_DET_V;
APPS.MST_R_MASTER_ORDER_DET_V is not referenced by any database object
|
|
|