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.WSH_USA_CATEGORIES_PVT dependencies on WSH_DELIVERY_DETAILS

Line 7: p_source_code IN WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE) IS

3:
4: -- 2071048
5: CURSOR c_cache_attributes_1(p_source_line_id IN NUMBER,
6: p_delivery_detail_id IN NUMBER,
7: p_source_code IN WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE) IS
8: SELECT source_line_id,
9: source_code,
10: organization_id,
11: inventory_item_id, --bug#6407943

Line 43: FROM wsh_delivery_details

39: delivery_detail_id) delivery_detail_id,
40: 'Y' cache_flag,
41: project_id,
42: task_id
43: FROM wsh_delivery_details
44: WHERE source_line_id = p_source_line_id
45: AND source_code = p_source_code
46: AND delivery_detail_id = DECODE(p_delivery_detail_id, FND_API.G_MISS_NUM,
47: delivery_detail_id, p_delivery_detail_id)

Line 57: p_source_code IN WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE) IS

53: 'X', 3,
54: 4);
55: CURSOR c_cache_attributes_2(p_source_line_id IN NUMBER,
56: p_delivery_detail_id IN NUMBER,
57: p_source_code IN WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE) IS
58: SELECT source_line_id,
59: source_code,
60: organization_id,
61: inventory_item_id, --bug#6407943

Line 93: FROM wsh_delivery_details

89: delivery_detail_id) delivery_detail_id,
90: 'Y' cache_flag,
91: project_id,
92: task_id
93: FROM wsh_delivery_details
94: WHERE source_line_id = p_source_line_id
95: AND source_code = p_source_code
96: AND delivery_detail_id = DECODE(p_delivery_detail_id, FND_API.G_MISS_NUM,
97: delivery_detail_id, p_delivery_detail_id)

Line 921: from wsh_delivery_details wdd

917: , NVL(wnd.planned_flag, 'N')
918: , NVL(wnd.tms_interface_flag, 'NS')
919: , wdd.replenishment_status
920: , wdd.client_id -- LSP PROJECT
921: from wsh_delivery_details wdd
922: , wsh_delivery_assignments wda
923: , wsh_new_deliveries wnd
924: where wdd.source_line_id = p_attributes_rec.source_line_id
925: and wdd.source_code = p_source_code

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

928: order by decode(wdd.released_status, 'Y', 1, 2);
929:
930: CURSOR c_del_status IS
931: SELECT wnd.status_code,wsp.export_screening_flag
932: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd,
933: wsh_shipping_parameters wsp
934: WHERE wdd.source_code = p_source_code
935: AND wdd.source_line_id = p_attributes_rec.source_line_id
936: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 951: FROM wsh_delivery_details

947:
948: --Bug#8518110 : item sub. is enabled for backorder dds also
949: CURSOR c_det_status IS
950: SELECT 'N'
951: FROM wsh_delivery_details
952: WHERE source_line_id = p_attributes_rec.source_line_id
953: AND source_code = p_source_code
954: AND released_status IN ('S','Y','C');
955:

Line 958: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

954: AND released_status IN ('S','Y','C');
955:
956: CURSOR c_packed_det IS
957: SELECT 'N'
958: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
959: WHERE wdd.source_line_id = p_attributes_rec.source_line_id
960: AND wdd.source_code = p_source_code
961: AND wdd.released_status <> 'D'
962: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 990: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

986: l_pickable_flag VARCHAR2(1);
987: l_reservable_flag VARCHAR2(1);
988: l_serial_number VARCHAR2(30);
989: l_trx_temp_id NUMBER;
990: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
991: l_count NUMBER;
992: l_msg_count NUMBER;
993: l_msg_data VARCHAR2(2000);
994: l_reservation_id NUMBER;

Line 1438: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1434:
1435: l_change_sub_only := 'X';
1436:
1437: ELSE
1438: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1439: x_item_id => l_item_id,
1440: x_organization_id => g_cache_detail_rec.organization_id,
1441: x_pickable_flag => l_pickable_flag);
1442:

Line 1527: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

1523: -- unreleased lines can stay in their deliveries.
1524: IF l_status IN ('S', 'Y') THEN
1525:
1526: IF l_delivery IS NOT NULL THEN
1527: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
1528: p_detail_id => l_del_det,
1529: p_validate_flag => 'N',
1530: x_return_status => x_return_status);
1531:

Line 1555: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

1551:
1552: END IF;
1553:
1554: IF l_parent_det IS NOT NULL THEN
1555: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
1556: p_detail_id => l_del_det,
1557: p_validate_flag => 'N',
1558: x_return_status => x_return_status);
1559:

Line 1586: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1582: END IF; --l_status IN ('S', 'Y')
1583:
1584: IF (l_serial_number IS NOT NULL) OR (l_trx_temp_id IS NOT NULL) THEN
1585:
1586: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1587: p_delivery_detail_id => l_del_det,
1588: p_inventory_item_id => l_item_id,
1589: p_organization_id => g_cache_detail_rec.organization_id,
1590: p_subinventory => l_subinventory,

Line 1599: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (

1595:
1596: RAISE update_not_allowed;
1597:
1598: END IF;
1599: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (
1600: p_delivery_detail_id => l_del_det,
1601: p_serial_number_code => l_inv_controls.serial_code,
1602: p_serial_number => l_serial_number,
1603: p_transaction_temp_id => l_trx_temp_id,

Line 1630: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail

1626: WSH_DEBUG_SV.logmsg(l_module_name, 'DET PICKED QTY AGAIN = ' || L_DET_PIC_QTY );
1627: END IF;
1628:
1629: -- HW OPMCONV - Pass Qty2
1630: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail
1631: (
1632: p_delivery_detail_id => l_del_det,
1633: p_quantity_to_unreserve => (l_det_pic_qty - l_det_req_qty),
1634: p_quantity2_to_unreserve => (l_det_pic_qty2 - l_det_req_qty2),

Line 1747: UPDATE wsh_delivery_details

1743: WSH_DEBUG_SV.logmsg(l_module_name, 'l_requested_quantity_uom2 = '||l_requested_quantity_uom2 );
1744: END IF;
1745:
1746:
1747: UPDATE wsh_delivery_details
1748: SET subinventory = NULL
1749: , lot_number = NULL
1750: , locator_id = NULL
1751: , revision = NULL

Line 1823: -- Update of wsh_delivery_details where released_status

1819:
1820: CLOSE c_delivery_detail;
1821: --
1822: -- DBI Project
1823: -- Update of wsh_delivery_details where released_status
1824: -- are changed, call DBI API after the update.
1825: -- This API will also check for DBI Installed or not
1826: IF l_debug_on THEN
1827: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API. delivery details l_detail_tab count',l_detail_tab.count);

Line 2241: from wsh_delivery_details

2237: IS
2238:
2239: cursor c_delivery_detail is
2240: select delivery_detail_id, ship_from_location_id,released_status,move_order_line_id
2241: from wsh_delivery_details
2242: where source_line_id = p_attributes_rec.source_line_id
2243: and source_code = p_source_code;
2244:
2245: l_orig_date DATE;

Line 2441: from wsh_delivery_details

2437: -- Bug 2995052 : Ship Set can be assigned to a order line even if it contains
2438: -- back order and ready to release delivery details.
2439: cursor c_get_released_status is
2440: select count(distinct(decode(released_status,'B','R',released_status)))
2441: from wsh_delivery_details
2442: where source_line_id = p_attributes_rec.source_line_id
2443: and source_code = p_source_code
2444: and released_status NOT IN ('X','D');
2445:

Line 2449: from wsh_delivery_details

2445:
2446: -- bug 2153719: ignore released_status 'X' and 'D'
2447: cursor c_get_details is
2448: select delivery_detail_id, released_status, move_order_line_id
2449: from wsh_delivery_details
2450: where source_line_id = p_attributes_rec.source_line_id
2451: and source_code = p_source_code
2452: and released_status NOT IN ('X', 'D')
2453: order by decode(released_status, 'Y', 1, 2);

Line 2690: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

2686: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2687: wda.delivery_id, wda.parent_delivery_detail_id,
2688: wdd.released_status, wnd.service_level service_level, wnd.mode_of_transport mode_of_transport,
2689: wnd.carrier_id carrier_id, wnd.ship_method_code ship_method_code
2690: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2691: where wdd.source_line_id = p_source_line_id
2692: and wdd.source_code = p_source_code
2693: and wdd.delivery_detail_id = wda.delivery_detail_id
2694: and wda.delivery_id = wnd.delivery_id

Line 2700: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_details wddp

2696: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2697: wda.delivery_id, wda.parent_delivery_detail_id,
2698: wdd.released_status, wddp.service_level service_level, wddp.mode_of_transport mode_of_transport,
2699: wddp.carrier_id carrier_id, wdd.ship_method_code ship_method_code
2700: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_details wddp
2701: where wdd.source_line_id = p_source_line_id
2702: and wdd.source_code = p_source_code
2703: and wdd.delivery_detail_id = wda.delivery_detail_id
2704: and wda.parent_delivery_detail_id = wddp.delivery_detail_id

Line 3001: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

2997: --
2998:
2999: IF dd.delivery_id IS NOT NULL THEN
3000:
3001: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
3002: p_detail_id => dd.delivery_detail_id,
3003: p_validate_flag => 'N',
3004: x_return_status => x_return_status);
3005:

Line 3049: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

3045: END IF;
3046:
3047: IF dd.parent_delivery_detail_id IS NOT NULL THEN
3048:
3049: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
3050: p_detail_id => dd.delivery_detail_id,
3051: p_validate_flag => 'N',
3052: x_return_status => x_return_status);
3053:

Line 3175: WSH_DELIVERY_DETAILS_PKG.Table_to_Record(

3171: OR l_group_tab(l_group_index).mode_of_transport IS NOT NULL
3172: OR l_group_tab(l_group_index).carrier_id IS NOT NULL THEN
3173:
3174:
3175: WSH_DELIVERY_DETAILS_PKG.Table_to_Record(
3176: p_delivery_detail_id => dd.parent_delivery_detail_id,
3177: x_delivery_detail_rec => l_detail_info_tab(1),
3178: x_return_status => x_return_status);
3179:

Line 3319: FROM wsh_delivery_details

3315: -- line_set_id can be NULL or MISS_NUM also , when we need to match
3316: -- using source_line_id
3317: CURSOR c_get_released_status is
3318: SELECT delivery_detail_id
3319: FROM wsh_delivery_details
3320: WHERE (source_line_id = p_attributes_rec.source_line_id
3321: OR source_line_set_id = p_attributes_rec.source_line_set_id)
3322: AND source_code = p_source_code
3323: AND source_header_id = p_attributes_rec.source_header_id