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.GML_MOBILE_SHIP_CONFIRM dependencies on WSH_NEW_DELIVERIES

Line 42: wsh_new_deliveries wnd

38: SELECT count(*)
39: INTO unshipped_count
40: FROM wsh_delivery_details wdd,
41: wsh_delivery_assignments wda,
42: wsh_new_deliveries wnd
43: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
44: AND wda.delivery_id = wnd.delivery_id
45: AND wnd.delivery_id = p_delivery_id
46: AND wdd.ship_set_id = l_ship_set_id

Line 111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,

107: dd.serial_number, del.waybill, Nvl(msik.serial_number_control_code, 1),
108: dd.subinventory, Nvl(dd.locator_id,0),dd.tracking_number,
109: nvl(dd.transaction_temp_id,0),
110: dd.picked_quantity, dd.requested_quantity_uom2, NVL(dd.lot_number, ' '), NVL(dd.picked_quantity2,0)
111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
112: FROM wsh_new_deliveries del, wsh_delivery_details dd,
113: wsh_delivery_assignments da, mtl_system_items_kfv msik
114: WHERE da.delivery_id = del.delivery_id
115: AND da.delivery_detail_id = dd.delivery_detail_id

Line 112: FROM wsh_new_deliveries del, wsh_delivery_details dd,

108: dd.subinventory, Nvl(dd.locator_id,0),dd.tracking_number,
109: nvl(dd.transaction_temp_id,0),
110: dd.picked_quantity, dd.requested_quantity_uom2, NVL(dd.lot_number, ' '), NVL(dd.picked_quantity2,0)
111: ---FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
112: FROM wsh_new_deliveries del, wsh_delivery_details dd,
113: wsh_delivery_assignments da, mtl_system_items_kfv msik
114: WHERE da.delivery_id = del.delivery_id
115: AND da.delivery_detail_id = dd.delivery_detail_id
116: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )

Line 519: FROM wsh_new_deliveries wnd

515: open x_delivery_info for
516: SELECT wnd.name, wnd.delivery_id, nvl(wnd.gross_weight, 0), wnd.weight_uom_code,
517: wnd.waybill,' ',
518: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
519: FROM wsh_new_deliveries wnd
520: WHERE wnd.delivery_id = p_delivery_id;
521: END GET_DELIVERY_INFO;
522:
523:

Line 713: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda,wsh_delivery_details wdd

709: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
710:
711: wnd.waybill,
712: Get_Shipmethod_Meaning(wnd.ship_method_code)
713: FROM wsh_new_deliveries wnd, wsh_delivery_assignments wda,wsh_delivery_details wdd
714:
715: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
716: AND wda.delivery_id = wnd.delivery_id
717: and ( wdd.released_status = 'Y' or wdd.released_status = 'X')

Line 751: wsh_new_deliveries nd

747: SELECT DISTINCT msik.concatenated_segments concatenated_segments
748: , msik.inventory_item_id
749: , msik.description
750: FROM mtl_system_items_kfv msik, wsh_delivery_details dd, wsh_delivery_assignments da,
751: wsh_new_deliveries nd
752: WHERE msik.concatenated_segments LIKE (p_concatenated_segments)
753: AND msik.organization_id = p_organization_id
754: AND msik.inventory_item_id = dd.inventory_item_id
755: AND nd.delivery_id = p_delivery_id

Line 772: wsh_new_deliveries nd,

768: , msik.description
769: FROM mtl_system_items_kfv msik,
770: wsh_delivery_details dd,
771: wsh_delivery_assignments da,
772: wsh_new_deliveries nd,
773: mtl_cross_references mcr
774: WHERE msik.organization_id = p_organization_id
775: AND msik.inventory_item_id = dd.inventory_item_id
776: