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 901: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd

897: wdd.weight_uom_code, wdd.volume_uom_code,
898: wdd.original_subinventory, wdd.pickable_flag ,
899: NVL(wnd.status_code, 'OP'), NVL(wnd.planned_flag, 'N'), NVL(wnd.tms_interface_flag, 'NS'),
900: wdd.replenishment_status
901: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd
902: where wdd.source_line_id = p_attributes_rec.source_line_id
903: and wdd.source_code = p_source_code
904: and wdd.delivery_detail_id = wda.delivery_detail_id
905: and wda.delivery_id = wnd.delivery_id(+)

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

906: order by decode(wdd.released_status, 'Y', 1, 2);
907:
908: CURSOR c_del_status IS
909: SELECT wnd.status_code,wsp.export_screening_flag
910: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd,
911: wsh_shipping_parameters wsp
912: WHERE wdd.source_code = p_source_code
913: AND wdd.source_line_id = p_attributes_rec.source_line_id
914: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 928: FROM wsh_delivery_details

924: AND organization_id = c_p_organization_id;
925:
926: CURSOR c_det_status IS
927: SELECT 'N'
928: FROM wsh_delivery_details
929: WHERE source_line_id = p_attributes_rec.source_line_id
930: AND source_code = p_source_code
931: AND released_status IN ('S','Y','C','B');
932:

Line 935: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

931: AND released_status IN ('S','Y','C','B');
932:
933: CURSOR c_packed_det IS
934: SELECT 'N'
935: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
936: WHERE wdd.source_line_id = p_attributes_rec.source_line_id
937: AND wdd.source_code = p_source_code
938: AND wdd.released_status <> 'D'
939: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 967: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

963: l_pickable_flag VARCHAR2(1);
964: l_reservable_flag VARCHAR2(1);
965: l_serial_number VARCHAR2(30);
966: l_trx_temp_id NUMBER;
967: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
968: l_count NUMBER;
969: l_msg_count NUMBER;
970: l_msg_data VARCHAR2(2000);
971: l_reservation_id NUMBER;

Line 1365: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1361:
1362: l_change_sub_only := 'X';
1363:
1364: ELSE
1365: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1366: x_item_id => l_item_id,
1367: x_organization_id => g_cache_detail_rec.organization_id,
1368: x_pickable_flag => l_pickable_flag);
1369:

Line 1454: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

1450: -- unreleased lines can stay in their deliveries.
1451: IF l_status IN ('S', 'Y') THEN
1452:
1453: IF l_delivery IS NOT NULL THEN
1454: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
1455: p_detail_id => l_del_det,
1456: p_validate_flag => 'N',
1457: x_return_status => x_return_status);
1458:

Line 1482: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

1478:
1479: END IF;
1480:
1481: IF l_parent_det IS NOT NULL THEN
1482: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
1483: p_detail_id => l_del_det,
1484: p_validate_flag => 'N',
1485: x_return_status => x_return_status);
1486:

Line 1513: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1509: END IF; --l_status IN ('S', 'Y')
1510:
1511: IF (l_serial_number IS NOT NULL) OR (l_trx_temp_id IS NOT NULL) THEN
1512:
1513: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1514: p_delivery_detail_id => l_del_det,
1515: p_inventory_item_id => l_item_id,
1516: p_organization_id => g_cache_detail_rec.organization_id,
1517: p_subinventory => l_subinventory,

Line 1526: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (

1522:
1523: RAISE update_not_allowed;
1524:
1525: END IF;
1526: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (
1527: p_delivery_detail_id => l_del_det,
1528: p_serial_number_code => l_inv_controls.serial_code,
1529: p_serial_number => l_serial_number,
1530: p_transaction_temp_id => l_trx_temp_id,

Line 1557: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail

1553: WSH_DEBUG_SV.logmsg(l_module_name, 'DET PICKED QTY AGAIN = ' || L_DET_PIC_QTY );
1554: END IF;
1555:
1556: -- HW OPMCONV - Pass Qty2
1557: WSH_DELIVERY_DETAILS_ACTIONS.Unreserve_delivery_detail
1558: (
1559: p_delivery_detail_id => l_del_det,
1560: p_quantity_to_unreserve => (l_det_pic_qty - l_det_req_qty),
1561: p_quantity2_to_unreserve => (l_det_pic_qty2 - l_det_req_qty2),

Line 1645: UPDATE wsh_delivery_details

1641: END IF;
1642: --
1643: -- HW OPM for OM changes. Added preferred_grade
1644: --HW OPMCONV -Added Qty2s
1645: UPDATE wsh_delivery_details
1646: SET subinventory = NULL,
1647: lot_number = NULL,
1648: locator_id = NULL,
1649: revision = NULL,

Line 1721: -- Update of wsh_delivery_details where released_status

1717:
1718: CLOSE c_delivery_detail;
1719: --
1720: -- DBI Project
1721: -- Update of wsh_delivery_details where released_status
1722: -- are changed, call DBI API after the update.
1723: -- This API will also check for DBI Installed or not
1724: IF l_debug_on THEN
1725: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API. delivery details l_detail_tab count',l_detail_tab.count);

Line 2135: from wsh_delivery_details

2131: IS
2132:
2133: cursor c_delivery_detail is
2134: select delivery_detail_id, ship_from_location_id
2135: from wsh_delivery_details
2136: where source_line_id = p_attributes_rec.source_line_id
2137: and source_code = p_source_code;
2138:
2139: l_orig_date DATE;

Line 2283: from wsh_delivery_details

2279: -- Bug 2995052 : Ship Set can be assigned to a order line even if it contains
2280: -- back order and ready to release delivery details.
2281: cursor c_get_released_status is
2282: select count(distinct(decode(released_status,'B','R',released_status)))
2283: from wsh_delivery_details
2284: where source_line_id = p_attributes_rec.source_line_id
2285: and source_code = p_source_code
2286: and released_status NOT IN ('X','D');
2287:

Line 2291: from wsh_delivery_details

2287:
2288: -- bug 2153719: ignore released_status 'X' and 'D'
2289: cursor c_get_details is
2290: select delivery_detail_id, released_status, move_order_line_id
2291: from wsh_delivery_details
2292: where source_line_id = p_attributes_rec.source_line_id
2293: and source_code = p_source_code
2294: and released_status NOT IN ('X', 'D')
2295: order by decode(released_status, 'Y', 1, 2);

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

2528: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2529: wda.delivery_id, wda.parent_delivery_detail_id,
2530: wdd.released_status, wnd.service_level service_level, wnd.mode_of_transport mode_of_transport,
2531: wnd.carrier_id carrier_id, wnd.ship_method_code ship_method_code
2532: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2533: where wdd.source_line_id = p_source_line_id
2534: and wdd.source_code = p_source_code
2535: and wdd.delivery_detail_id = wda.delivery_detail_id
2536: and wda.delivery_id = wnd.delivery_id

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

2538: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2539: wda.delivery_id, wda.parent_delivery_detail_id,
2540: wdd.released_status, wddp.service_level service_level, wddp.mode_of_transport mode_of_transport,
2541: wddp.carrier_id carrier_id, wdd.ship_method_code ship_method_code
2542: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_details wddp
2543: where wdd.source_line_id = p_source_line_id
2544: and wdd.source_code = p_source_code
2545: and wdd.delivery_detail_id = wda.delivery_detail_id
2546: and wda.parent_delivery_detail_id = wddp.delivery_detail_id

Line 2843: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

2839: --
2840:
2841: IF dd.delivery_id IS NOT NULL THEN
2842:
2843: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
2844: p_detail_id => dd.delivery_detail_id,
2845: p_validate_flag => 'N',
2846: x_return_status => x_return_status);
2847:

Line 2891: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

2887: END IF;
2888:
2889: IF dd.parent_delivery_detail_id IS NOT NULL THEN
2890:
2891: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
2892: p_detail_id => dd.delivery_detail_id,
2893: p_validate_flag => 'N',
2894: x_return_status => x_return_status);
2895:

Line 3017: WSH_DELIVERY_DETAILS_PKG.Table_to_Record(

3013: OR l_group_tab(l_group_index).mode_of_transport IS NOT NULL
3014: OR l_group_tab(l_group_index).carrier_id IS NOT NULL THEN
3015:
3016:
3017: WSH_DELIVERY_DETAILS_PKG.Table_to_Record(
3018: p_delivery_detail_id => dd.parent_delivery_detail_id,
3019: x_delivery_detail_rec => l_detail_info_tab(1),
3020: x_return_status => x_return_status);
3021:

Line 3161: FROM wsh_delivery_details

3157: -- line_set_id can be NULL or MISS_NUM also , when we need to match
3158: -- using source_line_id
3159: CURSOR c_get_released_status is
3160: SELECT delivery_detail_id
3161: FROM wsh_delivery_details
3162: WHERE (source_line_id = p_attributes_rec.source_line_id
3163: OR source_line_set_id = p_attributes_rec.source_line_set_id)
3164: AND source_code = p_source_code
3165: AND source_header_id = p_attributes_rec.source_header_id