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.

VIEW: APPS.MST_SHIP_SET_VIOLATION_DEL_V

Source

View Text - Preformatted


SELECT med.plan_id , md.delivery_id , mdd.source_code , mdd.source_header_number , decode ( mdd.split_from_delivery_detail_id, null, mdd.sr_delivery_detail_id, mdd.delivery_detail_id ) , md.delivery_number , substr ( mst_wb_util.get_name ( mdd.ship_from_location_id ), 1, 80 ) , wl1.address1 , wl1.city , wl1.state , wl1.postal_code , wl1.country , substr ( mst_wb_util.get_name ( mdd.ship_to_location_id ), 1, 80 ) , wl2.address1 , wl2.city , wl2.state , wl2.postal_code , wl2.country , msikfv.concatenated_segments , msitl.description , nvl ( mdd.gross_weight, 0 ) , mp.weight_uom , nvl ( mdd.volume, 0 ) , mp.volume_uom , round(nvl ( mdd.number_of_pallets, 0 )) , nvl ( mdd.requested_quantity, 0 ) , mdd.earliest_pickup_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_from_location_id, mdd.earliest_pickup_date ), 1, 40 ) , mdd.latest_pickup_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_from_location_id, mdd.latest_pickup_date ), 1, 40 ) , md.pickup_date , substr ( mst_wb_util.get_local_chardtzone ( md.dropoff_location_id, md.pickup_date ), 1, 40 ) , mdd.earliest_acceptable_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_to_location_id, mdd.earliest_acceptable_date ), 1, 40 ) , mdd.latest_acceptable_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_to_location_id, mdd.earliest_acceptable_date ), 1, 40 ) from mst_exception_details med , mst_deliveries md , mst_delivery_details mdd , wsh_locations wl1 , wsh_locations wl2 , mtl_system_items_kfv msikfv , mtl_system_items_tl msitl , mst_plans mp , mst_delivery_assignments mda WHERE med.plan_id = mdd.plan_id and med.number1 = mdd.ship_set_id and mdd.plan_id = mda.plan_id (+) and mdd.delivery_detail_id = mda.delivery_detail_id (+) and mda.plan_id = md.plan_id (+) and mda.delivery_id = md.delivery_id (+) and mdd.ship_from_location_id = wl1.wsh_location_id and mdd.ship_to_location_id = wl2.wsh_location_id and mdd.inventory_item_id = msikfv.inventory_item_id and mdd.organization_id = msikfv.organization_id and mdd.inventory_item_id = msitl.inventory_item_id and mdd.organization_id = msitl.organization_id and msitl.language = userenv('LANG') and med.plan_id = mp.plan_id union all select med.plan_id , md.delivery_id , mdd.source_code , mdd.source_header_number , decode ( mdd.split_from_delivery_detail_id, null, mdd.sr_delivery_detail_id, mdd.delivery_detail_id ) , md.delivery_number , substr ( mst_wb_util.get_name ( mdd.ship_from_location_id ), 1, 80 ) , wl1.address1 , wl1.city , wl1.state , wl1.postal_code , wl1.country , substr ( mst_wb_util.get_name ( mdd.ship_to_location_id ), 1, 80 ) , wl2.address1 , wl2.city , wl2.state , wl2.postal_code , wl2.country , msikfv.concatenated_segments , msitl.description , nvl ( mdd.gross_weight, 0 ) , mp.weight_uom , nvl ( mdd.volume, 0 ) , mp.volume_uom , round(nvl ( mdd.number_of_pallets, 0 )) , nvl ( mdd.requested_quantity, 0 ) , mdd.earliest_pickup_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_from_location_id, mdd.earliest_pickup_date ), 1, 40 ) , mdd.latest_pickup_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_from_location_id, mdd.latest_pickup_date ), 1, 40 ) , md.pickup_date , substr ( mst_wb_util.get_local_chardtzone ( md.dropoff_location_id, md.pickup_date ), 1, 40 ) , mdd.earliest_acceptable_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_to_location_id, mdd.earliest_acceptable_date ), 1, 40 ) , mdd.latest_acceptable_date , substr ( mst_wb_util.get_local_chardtzone ( mdd.ship_to_location_id, mdd.earliest_acceptable_date ), 1, 40 ) from mst_exception_details med , mst_deliveries md , mst_delivery_details mdd , wsh_locations wl1 , wsh_locations wl2 , mtl_system_items_kfv msikfv , mtl_system_items_tl msitl , mst_plans mp , mst_delivery_assignments mda where med.plan_id = mdd.plan_id and med.number2 = mdd.top_model_line_id and mdd.plan_id = mda.plan_id (+) and mdd.delivery_detail_id = mda.delivery_detail_id (+) and mda.plan_id = md.plan_id (+) and mda.delivery_id = md.delivery_id (+) and mdd.ship_from_location_id = wl1.wsh_location_id and mdd.ship_to_location_id = wl2.wsh_location_id and mdd.inventory_item_id = msikfv.inventory_item_id and mdd.organization_id = msikfv.organization_id and mdd.inventory_item_id = msitl.inventory_item_id and mdd.organization_id = msitl.organization_id and msitl.language = userenv('LANG') and med.plan_id = mp.plan_id

View Text - HTML Formatted

SELECT MED.PLAN_ID
, MD.DELIVERY_ID
, MDD.SOURCE_CODE
, MDD.SOURCE_HEADER_NUMBER
, DECODE ( MDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, NULL
, MDD.SR_DELIVERY_DETAIL_ID
, MDD.DELIVERY_DETAIL_ID )
, MD.DELIVERY_NUMBER
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_FROM_LOCATION_ID )
, 1
, 80 )
, WL1.ADDRESS1
, WL1.CITY
, WL1.STATE
, WL1.POSTAL_CODE
, WL1.COUNTRY
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_TO_LOCATION_ID )
, 1
, 80 )
, WL2.ADDRESS1
, WL2.CITY
, WL2.STATE
, WL2.POSTAL_CODE
, WL2.COUNTRY
, MSIKFV.CONCATENATED_SEGMENTS
, MSITL.DESCRIPTION
, NVL ( MDD.GROSS_WEIGHT
, 0 )
, MP.WEIGHT_UOM
, NVL ( MDD.VOLUME
, 0 )
, MP.VOLUME_UOM
, ROUND(NVL ( MDD.NUMBER_OF_PALLETS
, 0 ))
, NVL ( MDD.REQUESTED_QUANTITY
, 0 )
, MDD.EARLIEST_PICKUP_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_FROM_LOCATION_ID
, MDD.EARLIEST_PICKUP_DATE )
, 1
, 40 )
, MDD.LATEST_PICKUP_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_FROM_LOCATION_ID
, MDD.LATEST_PICKUP_DATE )
, 1
, 40 )
, MD.PICKUP_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MD.DROPOFF_LOCATION_ID
, MD.PICKUP_DATE )
, 1
, 40 )
, MDD.EARLIEST_ACCEPTABLE_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_TO_LOCATION_ID
, MDD.EARLIEST_ACCEPTABLE_DATE )
, 1
, 40 )
, MDD.LATEST_ACCEPTABLE_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_TO_LOCATION_ID
, MDD.EARLIEST_ACCEPTABLE_DATE )
, 1
, 40 )
FROM MST_EXCEPTION_DETAILS MED
, MST_DELIVERIES MD
, MST_DELIVERY_DETAILS MDD
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, MTL_SYSTEM_ITEMS_TL MSITL
, MST_PLANS MP
, MST_DELIVERY_ASSIGNMENTS MDA
WHERE MED.PLAN_ID = MDD.PLAN_ID
AND MED.NUMBER1 = MDD.SHIP_SET_ID
AND MDD.PLAN_ID = MDA.PLAN_ID (+)
AND MDD.DELIVERY_DETAIL_ID = MDA.DELIVERY_DETAIL_ID (+)
AND MDA.PLAN_ID = MD.PLAN_ID (+)
AND MDA.DELIVERY_ID = MD.DELIVERY_ID (+)
AND MDD.SHIP_FROM_LOCATION_ID = WL1.WSH_LOCATION_ID
AND MDD.SHIP_TO_LOCATION_ID = WL2.WSH_LOCATION_ID
AND MDD.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND MDD.INVENTORY_ITEM_ID = MSITL.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSITL.ORGANIZATION_ID
AND MSITL.LANGUAGE = USERENV('LANG')
AND MED.PLAN_ID = MP.PLAN_ID UNION ALL SELECT MED.PLAN_ID
, MD.DELIVERY_ID
, MDD.SOURCE_CODE
, MDD.SOURCE_HEADER_NUMBER
, DECODE ( MDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, NULL
, MDD.SR_DELIVERY_DETAIL_ID
, MDD.DELIVERY_DETAIL_ID )
, MD.DELIVERY_NUMBER
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_FROM_LOCATION_ID )
, 1
, 80 )
, WL1.ADDRESS1
, WL1.CITY
, WL1.STATE
, WL1.POSTAL_CODE
, WL1.COUNTRY
, SUBSTR ( MST_WB_UTIL.GET_NAME ( MDD.SHIP_TO_LOCATION_ID )
, 1
, 80 )
, WL2.ADDRESS1
, WL2.CITY
, WL2.STATE
, WL2.POSTAL_CODE
, WL2.COUNTRY
, MSIKFV.CONCATENATED_SEGMENTS
, MSITL.DESCRIPTION
, NVL ( MDD.GROSS_WEIGHT
, 0 )
, MP.WEIGHT_UOM
, NVL ( MDD.VOLUME
, 0 )
, MP.VOLUME_UOM
, ROUND(NVL ( MDD.NUMBER_OF_PALLETS
, 0 ))
, NVL ( MDD.REQUESTED_QUANTITY
, 0 )
, MDD.EARLIEST_PICKUP_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_FROM_LOCATION_ID
, MDD.EARLIEST_PICKUP_DATE )
, 1
, 40 )
, MDD.LATEST_PICKUP_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_FROM_LOCATION_ID
, MDD.LATEST_PICKUP_DATE )
, 1
, 40 )
, MD.PICKUP_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MD.DROPOFF_LOCATION_ID
, MD.PICKUP_DATE )
, 1
, 40 )
, MDD.EARLIEST_ACCEPTABLE_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_TO_LOCATION_ID
, MDD.EARLIEST_ACCEPTABLE_DATE )
, 1
, 40 )
, MDD.LATEST_ACCEPTABLE_DATE
, SUBSTR ( MST_WB_UTIL.GET_LOCAL_CHARDTZONE ( MDD.SHIP_TO_LOCATION_ID
, MDD.EARLIEST_ACCEPTABLE_DATE )
, 1
, 40 )
FROM MST_EXCEPTION_DETAILS MED
, MST_DELIVERIES MD
, MST_DELIVERY_DETAILS MDD
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, MTL_SYSTEM_ITEMS_TL MSITL
, MST_PLANS MP
, MST_DELIVERY_ASSIGNMENTS MDA
WHERE MED.PLAN_ID = MDD.PLAN_ID
AND MED.NUMBER2 = MDD.TOP_MODEL_LINE_ID
AND MDD.PLAN_ID = MDA.PLAN_ID (+)
AND MDD.DELIVERY_DETAIL_ID = MDA.DELIVERY_DETAIL_ID (+)
AND MDA.PLAN_ID = MD.PLAN_ID (+)
AND MDA.DELIVERY_ID = MD.DELIVERY_ID (+)
AND MDD.SHIP_FROM_LOCATION_ID = WL1.WSH_LOCATION_ID
AND MDD.SHIP_TO_LOCATION_ID = WL2.WSH_LOCATION_ID
AND MDD.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND MDD.INVENTORY_ITEM_ID = MSITL.INVENTORY_ITEM_ID
AND MDD.ORGANIZATION_ID = MSITL.ORGANIZATION_ID
AND MSITL.LANGUAGE = USERENV('LANG')
AND MED.PLAN_ID = MP.PLAN_ID