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.

APPS.MST_AUDIT_REP_EXCP dependencies on MST_DELIVERIES

Line 841: FROM MST_DELIVERIES

837: thresholdPct NUMBER;
838:
839: CURSOR c_firmDel IS
840: SELECT delivery_id, NVL(gross_weight,0) weight, NVL(volume,0) volume
841: FROM MST_DELIVERIES
842: WHERE PLAN_ID = plan_idIn
843: AND (PLANNED_FLAG <> 2
844: OR PRESERVE_GROUPING_FLAG <> 2
845: OR KNOWN_TE_FIRM_STATUS <> 3);

Line 992: TYPE delivery_id_t IS TABLE OF MST_DELIVERIES.DELIVERY_ID%TYPE INDEX BY BINARY_INTEGER;

988: AND loc1.wsh_location_id = det.ship_from_location_id
989: AND loc2.wsh_location_id = det.ship_to_location_id;
990:
991: --Auxiliary data structures to cache all the data to insert in exception_details
992: TYPE delivery_id_t IS TABLE OF MST_DELIVERIES.DELIVERY_ID%TYPE INDEX BY BINARY_INTEGER;
993: TYPE delivery_detail_id_t IS TABLE OF MST_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
994: TYPE distance_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
995: TYPE time_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
996: