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.WMS_DIRECT_SHIP_PVT dependencies on WMS_DIRECT_SHIP_TEMP

Line 3397: FROM wms_direct_ship_temp

3393: AND lpn_id = l_outermost_lpn_id;
3394:
3395: DELETE FROM mtl_serial_numbers_temp
3396: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3397: FROM wms_direct_ship_temp
3398: WHERE lpn_id = p_outermost_lpn_id);
3399:
3400: DELETE FROM wms_direct_ship_temp
3401: WHERE organization_id = p_org_id

Line 3400: DELETE FROM wms_direct_ship_temp

3396: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3397: FROM wms_direct_ship_temp
3398: WHERE lpn_id = p_outermost_lpn_id);
3399:
3400: DELETE FROM wms_direct_ship_temp
3401: WHERE organization_id = p_org_id
3402: --AND lpn_id = p_outermost_lpn_id;
3403: /* part of bug fix 2538703 */
3404: AND lpn_id = l_outermost_lpn_id;

Line 3444: FROM wms_direct_ship_temp

3440: --Delete records from Mtl_Seral_Numbers_Temp if any
3441: BEGIN
3442: DELETE FROM mtl_serial_numbers_temp
3443: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3444: FROM wms_direct_ship_temp
3445: WHERE lpn_id = p_outermost_lpn_id);
3446: EXCEPTION
3447: WHEN NO_DATA_FOUND THEN
3448: NULL;

Line 3451: DELETE FROM wms_direct_ship_temp

3447: WHEN NO_DATA_FOUND THEN
3448: NULL;
3449: END;
3450:
3451: DELETE FROM wms_direct_ship_temp
3452: WHERE lpn_id = p_outermost_lpn_id;
3453:
3454: IF (l_debug = 1) THEN
3455: DEBUG('Deleted temp recs for the case when trip id is not passed', 'CLEANUP_TEMP_RECS');

Line 4697: FROM wms_direct_ship_temp wds,

4693: , l_shipped_qty
4694: , l_primary_uom_code
4695: , l_lot_control_code
4696: , l_serial_number_control_code
4697: FROM wms_direct_ship_temp wds,
4698: wsh_delivery_details wdd,
4699: mtl_system_items msi
4700: WHERE wds.organization_id = p_organization_id
4701: AND wds.lpn_id = p_lpn_id

Line 4908: FROM WMS_DIRECT_SHIP_TEMP WDS,

4904: ,l_delivery_detail_tab(i).REQUESTED_QUANTITY
4905: ,l_delivery_detail_tab(i).PRIMARY_UOM_CODE
4906: ,l_delivery_detail_tab(i).LOT_CONTROL_CODE
4907: ,l_delivery_detail_tab(i).SERIAL_NUMBER_CONTROL_CODE
4908: FROM WMS_DIRECT_SHIP_TEMP WDS,
4909: WSH_DELIVERY_DETAILS WDD,
4910: MTL_SYSTEM_ITEMS MSI
4911: WHERE WDS.ORGANIZATION_ID = p_organization_id
4912: AND WDS.lpn_id = p_lpn_id

Line 4937: FROM wms_direct_ship_temp

4933: , p_dock_door_id IN NUMBER
4934: ) IS
4935: CURSOR outer_lpn IS
4936: SELECT DISTINCT lpn_id
4937: FROM wms_direct_ship_temp
4938: WHERE GROUP_ID = p_group_id
4939: AND organization_id = p_organization_id
4940: AND dock_door_id = p_dock_door_id;
4941:

Line 4954: FROM wms_direct_ship_temp wds

4950: , sub.reservable_type
4951: , msi.reservable_type
4952: , msi.lot_control_code
4953: , msi.serial_number_control_code
4954: FROM wms_direct_ship_temp wds
4955: , wms_license_plate_numbers wlpn
4956: , mtl_secondary_inventories sub
4957: , mtl_system_items msi
4958: WHERE wds.GROUP_ID = p_group_id

Line 4987: , wms_direct_ship_temp wds

4983:
4984: CURSOR stage_delivery_detail(p_organization_id NUMBER, p_lpn_id NUMBER) IS
4985: SELECT wdd.delivery_detail_id
4986: FROM wsh_delivery_details_ob_grp_v wdd
4987: , wms_direct_ship_temp wds
4988: WHERE wds.organization_id = p_organization_id
4989: AND wds.lpn_id = p_lpn_id
4990: AND wdd.source_header_id = wds.order_header_id
4991: AND wdd.source_line_id = wds.order_line_id

Line 5149: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

5145: AND released_status = 'X'; -- For LPN reuse ER : 6845650
5146:
5147: SELECT wdd.delivery_detail_id
5148: INTO l_delivery_detail_id
5149: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
5150: WHERE wds.organization_id = p_organization_id
5151: AND wds.lpn_id = l_outer_lpn.lpn_id
5152: AND wdd.source_header_id = wds.order_header_id
5153: AND wdd.source_line_id = wds.order_line_id

Line 5335: ' FROM wms_direct_ship_temp wds, ' ||

5331: l_sql_query := l_sql_query || ' , NULL ont_pricing_qty_source ';
5332: END IF;
5333:
5334: l_sql_query := l_sql_query ||
5335: ' FROM wms_direct_ship_temp wds, ' ||
5336: ' wsh_delivery_details_ob_grp_v wdd, ' ||
5337: ' mtl_system_items msi ' ||
5338: ' WHERE wds.organization_id = :p_organization_id ' ||
5339: ' AND wds.lpn_id = :p_lpn_id ' ||

Line 5634: UPDATE wms_direct_ship_temp

5630: INTO l_delivery_detail_tab(i).transaction_temp_id
5631: FROM DUAL;
5632:
5633: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
5634: UPDATE wms_direct_ship_temp
5635: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id
5636: WHERE organization_id = l_delivery_detail_tab(i).organization_id
5637: AND lpn_id = l_delivery_detail_tab(i).lpn_id
5638: AND dock_door_id = l_delivery_detail_tab(i).dock_door_id

Line 5905: UPDATE wms_direct_ship_temp

5901:
5902: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;
5903:
5904: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
5905: UPDATE wms_direct_ship_temp
5906: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id
5907: WHERE organization_id = l_delivery_detail_tab(i).organization_id
5908: AND lpn_id = l_delivery_detail_tab(i).lpn_id
5909: AND dock_door_id = l_delivery_detail_tab(i).dock_door_id

Line 8804: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

8800: WHERE released_status IN('R', 'B')
8801: AND source_line_id = l_order_line_rec.line_id
8802: UNION ALL -- bug 4232713 - Need to consider staged WDD lines for overpicking scenarios
8803: SELECT wdd.delivery_detail_id
8804: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
8805: WHERE wdd.released_status = 'Y'
8806: AND wdd.source_line_id = wds.order_line_id);
8807: EXCEPTION
8808: WHEN NO_DATA_FOUND THEN

Line 9156: INSERT INTO wms_direct_ship_temp

9152: ELSE
9153: l_trx_temp_id := NULL;
9154: END IF;
9155:
9156: INSERT INTO wms_direct_ship_temp
9157: (
9158: GROUP_ID
9159: , organization_id
9160: , dock_door_id

Line 10095: FROM wms_direct_ship_temp

10091: -- if record exist then update
10092: BEGIN
10093: SELECT order_line_id
10094: INTO l_temp_var
10095: FROM wms_direct_ship_temp
10096: WHERE organization_id = p_org_id
10097: AND dock_door_id = p_dock_door_id
10098: AND lpn_id = p_lpn_id
10099: AND order_header_id = p_order_header_id

Line 10104: UPDATE wms_direct_ship_temp

10100: AND order_line_id = p_order_line_id;
10101:
10102: -- no excaption means record exist
10103: -- update
10104: UPDATE wms_direct_ship_temp
10105: SET processed_flag = 'Y'
10106: , processed_quantity = l_processed_quantity
10107: WHERE organization_id = p_org_id
10108: AND dock_door_id = p_dock_door_id

Line 10134: INSERT INTO wms_direct_ship_temp

10130: ELSE
10131: l_trx_temp_id := NULL;
10132: END IF;
10133:
10134: INSERT INTO wms_direct_ship_temp
10135: (
10136: GROUP_ID
10137: , organization_id
10138: , dock_door_id

Line 10181: FROM wms_direct_ship_temp wdst

10177: IF l_mtl_resv_tab_count_temp >0 then Added bug4128854 for overshipping staged lines
10178:
10179: Bug#4349836.Before inserting a dummy record,check if one is already there for the same LPN
10180: SELECT count(1) INTO l_count_wdst
10181: FROM wms_direct_ship_temp wdst
10182: WHERE wdst.group_id = g_group_id
10183: AND wdst.organization_id=p_org_id
10184: AND wdst.dock_door_id = p_dock_door_id
10185: AND wdst.lpn_id=p_lpn_id

Line 10194: INSERT INTO wms_direct_ship_temp

10190:
10191: IF (l_debug = 1) THEN
10192: DEBUG('Processed quantity for line is zero. Record with zero inserted into wds', 'Process_Line');
10193: END IF;
10194: INSERT INTO wms_direct_ship_temp
10195: (
10196: GROUP_ID
10197: , organization_id
10198: , dock_door_id

Line 10371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

10367: FUNCTION validate_del_for_ds(p_lpn_id IN NUMBER, p_org_id IN NUMBER, p_dock_door_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER)
10368: RETURN BOOLEAN IS
10369: CURSOR del_cur IS
10370: SELECT wda.delivery_id
10371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
10372: WHERE wds.organization_id = p_org_id
10373: AND wds.dock_door_id = p_dock_door_id
10374: AND wds.lpn_id = p_lpn_id
10375: AND wds.order_header_id = p_header_id

Line 10477: FROM wms_direct_ship_temp wds

10473: --
10474: CURSOR wds_cur IS
10475: SELECT wds.order_header_id
10476: , wds.order_line_id
10477: FROM wms_direct_ship_temp wds
10478: WHERE wds.organization_id = p_org_id
10479: AND wds.dock_door_id = p_dock_door_id
10480: AND wds.lpn_id = p_lpn_id;
10481:

Line 10701: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi

10697: , oel.item_revision revision
10698: , oel.end_item_unit_number
10699: , oel.request_date
10700: , msi.primary_uom_code
10701: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
10702: WHERE wds.organization_id = p_org_id
10703: AND wds.GROUP_ID = g_group_id
10704: AND wds.dock_door_id = p_dock_door_id
10705: AND wds.lpn_id = p_lpn_id

Line 11139: UPDATE wms_direct_ship_temp

11135: END IF;
11136:
11137: -- update wds for processed_quantity=processed_quantity+g_total_lpn_quantity
11138: BEGIN
11139: UPDATE wms_direct_ship_temp
11140: SET processed_quantity =(processed_quantity + l_qty_overship)
11141: WHERE organization_id = p_org_id
11142: AND GROUP_ID = g_group_id
11143: AND lpn_id = p_lpn_id

Line 11491: UPDATE wms_direct_ship_temp

11487: -- debug('Line '||l_loaded_lines_rec.order_line_id||'overshipped for quantity '||l_qty_updt_resv,'Perform_Overship_Distribution');
11488: -- if all quantity consumed exit to lpn_content loop
11489: -- update wds for processed_quantity=processed_quantity+g_total_lpn_quantity
11490: BEGIN
11491: UPDATE wms_direct_ship_temp
11492: SET processed_quantity =(processed_quantity + l_qty_overship)
11493: WHERE organization_id = p_org_id
11494: AND GROUP_ID = g_group_id
11495: AND lpn_id = p_lpn_id

Line 11687: DELETE wms_direct_ship_temp

11683: IF (l_debug = 1) THEN
11684: DEBUG('Clean up bad data for lpn=' || l_lpn_cur.lpn_id, 'Cleanup_Orphan_Rec');
11685: END IF;
11686:
11687: DELETE wms_direct_ship_temp
11688: WHERE lpn_id = l_lpn_cur.lpn_id;
11689:
11690: DELETE wms_freight_cost_temp
11691: WHERE lpn_id = l_lpn_cur.lpn_id;