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 3587: FROM wms_direct_ship_temp

3583: AND lpn_id = l_outermost_lpn_id;
3584:
3585: DELETE FROM mtl_serial_numbers_temp
3586: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3587: FROM wms_direct_ship_temp
3588: WHERE lpn_id = p_outermost_lpn_id);
3589:
3590: DELETE FROM wms_direct_ship_temp
3591: WHERE organization_id = p_org_id

Line 3590: DELETE FROM wms_direct_ship_temp

3586: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3587: FROM wms_direct_ship_temp
3588: WHERE lpn_id = p_outermost_lpn_id);
3589:
3590: DELETE FROM wms_direct_ship_temp
3591: WHERE organization_id = p_org_id
3592: --AND lpn_id = p_outermost_lpn_id;
3593: /* part of bug fix 2538703 */
3594: AND lpn_id = l_outermost_lpn_id;

Line 3634: FROM wms_direct_ship_temp

3630: --Delete records from Mtl_Seral_Numbers_Temp if any
3631: BEGIN
3632: DELETE FROM mtl_serial_numbers_temp
3633: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3634: FROM wms_direct_ship_temp
3635: WHERE lpn_id = p_outermost_lpn_id);
3636: EXCEPTION
3637: WHEN NO_DATA_FOUND THEN
3638: NULL;

Line 3641: DELETE FROM wms_direct_ship_temp

3637: WHEN NO_DATA_FOUND THEN
3638: NULL;
3639: END;
3640:
3641: DELETE FROM wms_direct_ship_temp
3642: WHERE lpn_id = p_outermost_lpn_id;
3643:
3644: IF (l_debug = 1) THEN
3645: DEBUG('Deleted temp recs for the case when trip id is not passed', 'CLEANUP_TEMP_RECS');

Line 4938: FROM wms_direct_ship_temp wds,

4934: , l_picked_qty
4935: , l_sec_picked_qty
4936: , l_shipped_qty
4937: , l_sec_shipped_qty
4938: FROM wms_direct_ship_temp wds,
4939: wsh_delivery_details_ob_grp_v wdd
4940: WHERE wds.organization_id = p_organization_id
4941: AND wds.lpn_id = p_lpn_id
4942: AND wds.order_header_id = p_source_header_id

Line 5185: FROM WMS_DIRECT_SHIP_TEMP WDS,

5181: ,l_delivery_detail_tab(i).REQUESTED_QUANTITY2
5182: ,l_delivery_detail_tab(i).REQUESTED_QUANTITY_UOM2
5183: ,l_delivery_detail_tab(i).LOT_CONTROL_CODE
5184: ,l_delivery_detail_tab(i).SERIAL_NUMBER_CONTROL_CODE
5185: FROM WMS_DIRECT_SHIP_TEMP WDS,
5186: WSH_DELIVERY_DETAILS WDD,
5187: MTL_SYSTEM_ITEMS MSI
5188: WHERE WDS.ORGANIZATION_ID = p_organization_id
5189: AND WDS.lpn_id = p_lpn_id

Line 5214: FROM wms_direct_ship_temp

5210: , p_dock_door_id IN NUMBER
5211: ) IS
5212: CURSOR outer_lpn IS
5213: SELECT DISTINCT lpn_id
5214: FROM wms_direct_ship_temp
5215: WHERE GROUP_ID = p_group_id
5216: AND organization_id = p_organization_id
5217: AND dock_door_id = p_dock_door_id;
5218:

Line 5232: FROM wms_direct_ship_temp wds

5228: , msi.inventory_item_id
5229: , msi.reservable_type
5230: , msi.lot_control_code
5231: , msi.serial_number_control_code
5232: FROM wms_direct_ship_temp wds
5233: , wms_license_plate_numbers wlpn
5234: , mtl_secondary_inventories sub
5235: , mtl_system_items msi
5236: WHERE wds.GROUP_ID = p_group_id

Line 5265: , wms_direct_ship_temp wds

5261:
5262: CURSOR stage_delivery_detail(p_organization_id NUMBER, p_lpn_id NUMBER) IS
5263: SELECT wdd.delivery_detail_id
5264: FROM wsh_delivery_details_ob_grp_v wdd
5265: , wms_direct_ship_temp wds
5266: WHERE wds.organization_id = p_organization_id
5267: AND wds.lpn_id = p_lpn_id
5268: AND wdd.source_header_id = wds.order_header_id
5269: AND wdd.source_line_id = wds.order_line_id

Line 5449: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

5445: AND released_status = 'X'; -- For LPN reuse ER : 6845650
5446:
5447: SELECT wdd.delivery_detail_id
5448: INTO l_delivery_detail_id
5449: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
5450: WHERE wds.organization_id = p_organization_id
5451: AND wds.lpn_id = l_outer_lpn.lpn_id
5452: AND wdd.source_header_id = wds.order_header_id
5453: AND wdd.source_line_id = wds.order_line_id

Line 5655: ' FROM wms_direct_ship_temp wds, ' ||

5651: l_sql_query := l_sql_query || ' , NULL ont_pricing_qty_source ';
5652: END IF;
5653:
5654: l_sql_query := l_sql_query ||
5655: ' FROM wms_direct_ship_temp wds, ' ||
5656: ' wsh_delivery_details_ob_grp_v wdd, ' ||
5657: ' mtl_system_items msi ' ||
5658: ' WHERE wds.organization_id = :p_organization_id ' ||
5659: ' AND wds.lpn_id = :p_lpn_id ' ||

Line 5977: UPDATE wms_direct_ship_temp

5973: INTO l_delivery_detail_tab(i).transaction_temp_id
5974: FROM DUAL;
5975:
5976: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
5977: UPDATE wms_direct_ship_temp
5978: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id
5979: WHERE organization_id = l_delivery_detail_tab(i).organization_id
5980: AND lpn_id = l_delivery_detail_tab(i).lpn_id
5981: AND dock_door_id = l_delivery_detail_tab(i).dock_door_id

Line 6324: UPDATE wms_direct_ship_temp

6320:
6321: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;
6322:
6323: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
6324: UPDATE wms_direct_ship_temp
6325: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id
6326: WHERE organization_id = l_delivery_detail_tab(i).organization_id
6327: AND lpn_id = l_delivery_detail_tab(i).lpn_id
6328: AND dock_door_id = l_delivery_detail_tab(i).dock_door_id

Line 6777: UPDATE wms_direct_ship_temp

6773: INTO l_delivery_detail_tab(i).transaction_temp_id
6774: FROM DUAL;
6775:
6776: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
6777: UPDATE wms_direct_ship_temp
6778: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id
6779: WHERE organization_id = l_delivery_detail_tab(i).organization_id
6780: AND lpn_id = l_delivery_detail_tab(i).lpn_id
6781: AND dock_door_id = l_delivery_detail_tab(i).dock_door_id

Line 7049: UPDATE wms_direct_ship_temp

7045:
7046: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;
7047:
7048: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
7049: UPDATE wms_direct_ship_temp
7050: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id
7051: WHERE organization_id = l_delivery_detail_tab(i).organization_id
7052: AND lpn_id = l_delivery_detail_tab(i).lpn_id
7053: AND dock_door_id = l_delivery_detail_tab(i).dock_door_id

Line 9988: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

9984: WHERE released_status IN('R','B')
9985: AND source_line_id = l_order_line_rec.line_id)
9986: -- bug 4232713 - Need to consider staged WDD lines for overpicking scenarios
9987: OR EXISTS(SELECT wdd.delivery_detail_id
9988: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
9989: WHERE wdd.released_status = 'Y'
9990: AND wdd.source_line_id = wds.order_line_id
9991: AND wds.order_line_id = l_order_line_rec.line_id);
9992: EXCEPTION

Line 10523: INSERT INTO wms_direct_ship_temp(

10519: ELSE
10520: l_trx_temp_id := NULL;
10521: END IF;
10522:
10523: INSERT INTO wms_direct_ship_temp(
10524: group_id
10525: , organization_id
10526: , dock_door_id
10527: , lpn_id

Line 11900: FROM wms_direct_ship_temp

11896: -- if record exist then update
11897: BEGIN --{
11898: SELECT order_line_id
11899: INTO l_temp_var
11900: FROM wms_direct_ship_temp
11901: WHERE organization_id = p_org_id
11902: AND dock_door_id = p_dock_door_id
11903: AND lpn_id = p_lpn_id
11904: AND order_header_id = p_order_header_id

Line 11908: UPDATE wms_direct_ship_temp

11904: AND order_header_id = p_order_header_id
11905: AND order_line_id = p_order_line_id;
11906:
11907: -- no excaption means record exist
11908: UPDATE wms_direct_ship_temp
11909: SET processed_flag = 'Y'
11910: , processed_quantity = l_processed_quantity
11911: , secondary_processed_qty = l_processed_sec_qty
11912: WHERE organization_id = p_org_id

Line 11937: INSERT INTO wms_direct_ship_temp(

11933: ELSE
11934: l_trx_temp_id := NULL;
11935: END IF;
11936:
11937: INSERT INTO wms_direct_ship_temp(
11938: group_id
11939: , organization_id
11940: , dock_door_id
11941: , lpn_id

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

12120: ) RETURN BOOLEAN IS
12121:
12122: CURSOR del_cur IS
12123: SELECT wda.delivery_id
12124: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
12125: WHERE wds.organization_id = p_org_id
12126: AND wds.dock_door_id = p_dock_door_id
12127: AND wds.lpn_id = p_lpn_id
12128: AND wds.order_header_id = p_header_id

Line 12258: FROM wms_direct_ship_temp wds

12254: --
12255: CURSOR wds_cur IS
12256: SELECT wds.order_header_id
12257: , wds.order_line_id
12258: FROM wms_direct_ship_temp wds
12259: WHERE wds.organization_id = p_org_id
12260: AND wds.dock_door_id = p_dock_door_id
12261: AND wds.lpn_id = p_lpn_id;
12262:

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

12483: , oel.end_item_unit_number
12484: , oel.request_date
12485: , msi.primary_uom_code
12486: , msi.secondary_uom_code
12487: FROM wms_direct_ship_temp wds, oe_order_lines_all oel, mtl_system_items_kfv msi
12488: WHERE wds.organization_id = p_org_id
12489: AND wds.GROUP_ID = g_group_id
12490: AND wds.dock_door_id = p_dock_door_id
12491: AND wds.lpn_id = p_lpn_id

Line 13057: UPDATE wms_direct_ship_temp

13053: END IF;
13054:
13055: -- update wds for processed_quantity=processed_quantity+g_total_lpn_quantity
13056: BEGIN
13057: UPDATE wms_direct_ship_temp
13058: SET processed_quantity = (processed_quantity + l_qty_overship)
13059: , secondary_processed_qty = (NVL(secondary_processed_qty,0) + NVL(l_sec_qty_overship,0))
13060: WHERE organization_id = p_org_id
13061: AND group_id = g_group_id

Line 13467: UPDATE wms_direct_ship_temp

13463:
13464: -- if all quantity consumed exit to lpn_content loop
13465: -- update wds for processed_quantity=processed_quantity+g_total_lpn_quantity
13466: BEGIN
13467: UPDATE wms_direct_ship_temp
13468: SET processed_quantity = (processed_quantity + l_qty_overship)
13469: , secondary_processed_qty = (NVL(secondary_processed_qty,0) + NVL(l_sec_qty_overship,0))
13470: WHERE organization_id = p_org_id
13471: AND group_id = g_group_id

Line 13671: DELETE wms_direct_ship_temp

13667: DEBUG('Orphaned record count: ' || l_lpn_tab.COUNT, 'Cleanup_Orphan_Rec');
13668: END IF;
13669:
13670: FORALL i IN l_lpn_tab.FIRST .. l_lpn_tab.LAST
13671: DELETE wms_direct_ship_temp
13672: WHERE lpn_id = l_lpn_tab(i);
13673:
13674: FORALL i IN l_lpn_tab.FIRST .. l_lpn_tab.LAST
13675: DELETE wms_freight_cost_temp