eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MST_AUDIT_EXCEPTIONS_V

Object Details

Object Name:	MST_AUDIT_EXCEPTIONS_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	Comments
PLAN_ID	NUMBER		FK to mst_plans
EXCEPTION_TYPE	NUMBER		Exception type
EXCEPTION_DETAIL_ID	NUMBER		FK to mst_exception_details
DELIVERY_ID	NUMBER		FK to mst_deliveries
TRIP_NUMBER	NUMBER		Trip number with in plan
FREIGHT_CODE	VARCHAR2	(30)	Carrier name
ORIGIN_FACILITY_ID	NUMBER		FK to fte_location_parameters
DESTINATION_FACILITY_ID	NUMBER		FK to fte_location_parameters
DELIVERY_NUMBER	NUMBER		TP Delivery Number
DELIVERY_DETAIL_ID	NUMBER		FK to mst_delivery_details
SOURCE_CODE	VARCHAR2	(30)	OE/WIP/PO
SOURCE_HEADER_NUMBER	VARCHAR2	(150)	The user visible identifier for the header, ex. Order number
SOURCE_LINE_NUMBER	VARCHAR2	(150)	User visible line number in source system
TP_REFER_HEADER_NUMBER	VARCHAR2	(50)	Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
REFERENCE_SOURCE_TYPE	VARCHAR2	(240)	Source type of the reference order SO, PO etc
ORIGIN_FACILITY	VARCHAR2	(60)	Origin facility
ORIGIN_FACILITY_DESC	VARCHAR2	(250)	Origin facility description
ORIGIN_COMPANY	VARCHAR2	(80)	Origin company
ORIGIN_ADDRESS	VARCHAR2	(240)	Origin address
ORIGIN_CITY	VARCHAR2	(120)	Origin city of trip
ORIGIN_STATE	VARCHAR2	(120)	Origin state
ORIGIN_ZIP	VARCHAR2	(60)	Origin zip code
ORIGIN_COUNTRY	VARCHAR2	(120)	Origin country
DESTINATION_FACILITY	VARCHAR2	(60)	Destination facility
DESTINATION_FACILITY_DESC	VARCHAR2	(250)	Destination facility description
DESTINATION_COMPANY	VARCHAR2	(80)	Destination company
DESTINATION_ADDRESS	VARCHAR2	(240)	Destination address
DESTINATION_CITY	VARCHAR2	(120)	Destination city
DESTINATION_STATE	VARCHAR2	(120)	Destination state
DESTINATION_ZIP	VARCHAR2	(60)	Destination zip code
DESTINATION_COUNTRY	VARCHAR2	(120)	Destination country
EARLIEST_PICKUP_DATE	VARCHAR2	(40)	Earliest pickup date in origin timezone of delivery detail
LATEST_PICKUP_DATE	VARCHAR2	(40)	Latest pickup date in origin timezone of delivery detail
EARLIEST_ACCEPTABLE_DATE	VARCHAR2	(40)	Earliest acceptable date in destination timezone of delivery detail
LATEST_ACCEPTABLE_DATE	VARCHAR2	(40)	Latest acceptable date in destination timezone of delivery detail
EARLIEST_PICKUP_DATE_1	DATE		Earliest pickup date
LATEST_PICKUP_DATE_1	DATE		Latest pickup date
EARLIEST_ACCEPTABLE_DATE_1	DATE		Earliest acceptable date
LATEST_ACCEPTABLE_DATE_1	DATE		Latest acceptable date
NUMBER3	VARCHAR2	(20)	Generic number column
NUMBER2	VARCHAR2	(20)	Generic number column
TRANSIT_TIME_SHORT	VARCHAR2	(20)	Transit time short
TIME_PAST_DUE	VARCHAR2	(20)	Time past due
ITEM_TYPE	VARCHAR2	(40)	Item type of delivery detail
ITEM_DESCRIPTION	VARCHAR2	(240)	Description of delivery detail
GROSS_WEIGHT	NUMBER		Gross weight of delivery detail
WEIGHT_UOM	VARCHAR2	(3)	Weight UOM
VOLUME	NUMBER		Volume of delivery detail
VOLUME_UOM	VARCHAR2	(3)	Volume UOM
NUMBER_OF_PALLETS	NUMBER		Number of pallets in delivery detail
REQUESTED_QUANTITY	NUMBER		Requested quantity of delivery detail
MAXIMUM_LOAD_WEIGHT	NUMBER		Maximum load weight allowed
INTERNAL_VOLUME	NUMBER		Internal volume
UNIT_LENGTH	NUMBER		Length of delivery detail
UNIT_WIDTH	NUMBER		Width of delivery detail
UNIT_HEIGHT	NUMBER		Height of delivery detail
DIMENSION_UOM_CODE	VARCHAR2	(3)	Dimension UOM
VEHICLE_UNIT_LENGTH	NUMBER		Length of vehicle
VEHICLE_UNIT_WIDTH	NUMBER		Width of vehicle
VEHICLE_UNIT_HEIGHT	NUMBER		Height of vehicle
VEHICLE_DIMENSION_UOM_CODE	VARCHAR2	(240)	Dimesion UOM of vehicle
STATUS	VARCHAR2	(80)	Exception status
THRESHOLD	VARCHAR2	(20)	Threshold value fo exception
WORKFLOW_STATUS	VARCHAR2	(20)	Workflow status of the exception

Query Text

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


SELECT PLAN_ID
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      DELIVERY_ID
,      TRIP_NUMBER
,      FREIGHT_CODE
,      ORIGIN_FACILITY_ID
,      DESTINATION_FACILITY_ID
,      DELIVERY_NUMBER
,      DELIVERY_DETAIL_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      SOURCE_LINE_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_COMPANY
,      ORIGIN_ADDRESS
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_COMPANY
,      DESTINATION_ADDRESS
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      EARLIEST_PICKUP_DATE_1
,      LATEST_PICKUP_DATE_1
,      EARLIEST_ACCEPTABLE_DATE_1
,      LATEST_ACCEPTABLE_DATE_1
,      NUMBER3
,      NUMBER2
,      TRANSIT_TIME_SHORT
,      TIME_PAST_DUE
,      ITEM_TYPE
,      ITEM_DESCRIPTION
,      GROSS_WEIGHT
,      WEIGHT_UOM
,      VOLUME
,      VOLUME_UOM
,      NUMBER_OF_PALLETS
,      REQUESTED_QUANTITY
,      MAXIMUM_LOAD_WEIGHT
,      INTERNAL_VOLUME
,      UNIT_LENGTH
,      UNIT_WIDTH
,      UNIT_HEIGHT
,      DIMENSION_UOM_CODE
,      VEHICLE_UNIT_LENGTH
,      VEHICLE_UNIT_WIDTH
,      VEHICLE_UNIT_HEIGHT
,      VEHICLE_DIMENSION_UOM_CODE
,      STATUS
,      THRESHOLD
,      WORKFLOW_STATUS
FROM APPS.MST_AUDIT_EXCEPTIONS_V;

Dependencies

[top of page]

APPS.MST_AUDIT_EXCEPTIONS_V references the following:

APPS: FTE_LOCATION_PARAMETERS; FTE_VEHICLE_TYPES; MFG_LOOKUPS; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_EXCEPTION_DETAILS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_B_KFV; MTL_SYSTEM_ITEMS_TL; WSH_CARRIERS; WSH_LOCATIONS

APPS.MST_AUDIT_EXCEPTIONS_V is not referenced by any database object