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_IB_UI_RECON_GRP dependencies on WSH_DELIVERY_DETAILS

Line 493: from wsh_delivery_details wdd,

489: wnd.rcv_shipment_header_id,
490: wnd.status_code,
491: wdd.picked_quantity,
492: wdd.shipped_quantity
493: from wsh_delivery_details wdd,
494: wsh_delivery_assignments_v wda,
495: wsh_new_deliveries wnd
496: where wnd.rcv_shipment_header_id = p_shipment_header_id
497: and wnd.delivery_id = wda.delivery_id

Line 508: from wsh_delivery_details wdd

504: cursor l_tot_ret_qty_csr(p_source_line_id NUMBER,
505: p_po_line_loc_id NUMBER) is
506: select sum(returned_quantity),
507: sum(returned_quantity2)
508: from wsh_delivery_details wdd
509: where source_line_id = p_source_line_id
510: and po_shipment_line_id = p_po_line_loc_id
511: and released_status = 'L'
512: and source_code = 'PO';

Line 520: from wsh_delivery_details wdd

516: -- matched against the receipt being reverted for a po_line_location_id.
517: cursor l_tot_req_qty_csr(p_source_line_id NUMBER,
518: p_po_line_loc_id NUMBER) is
519: select sum(requested_quantity), sum(requested_quantity2)
520: from wsh_delivery_details wdd
521: where source_line_id = p_source_line_id
522: and po_shipment_line_id = p_po_line_loc_id
523: and ( released_status = 'X'
524: or

Line 534: from wsh_delivery_details wdd,

530: -- This is not used anymore. Was added in the beginning.
531: cursor l_packed_del_lines_csr(p_source_line_id NUMBER,
532: p_po_line_loc_id NUMBER) is
533: select wdd.delivery_detail_id
534: from wsh_delivery_details wdd,
535: wsh_delivery_assignments_v wda
536: where wdd.source_line_id = p_source_line_id
537: and wdd.container_flag = 'N'
538: and wdd.source_code = 'PO'

Line 546: from wsh_delivery_details wdd,

542: -- This is not used anymore. Was added in the beginning.
543: cursor l_del_det_id_csr(p_shipment_header_id NUMBER) is
544: select wdd.po_shipment_line_id,
545: wdd.delivery_detail_id
546: from wsh_delivery_details wdd,
547: wsh_delivery_assignments_v wda,
548: wsh_new_deliveries wnd
549: where wnd.rcv_shipment_header_id = p_shipment_header_id
550: and wnd.delivery_id = wda.delivery_id

Line 554: -- This cursor checks whether atleast one record in wsh_delivery_details

550: and wnd.delivery_id = wda.delivery_id
551: and wda.delivery_detail_id = wdd.delivery_detail_id
552: and wdd.source_code = 'PO';
553:
554: -- This cursor checks whether atleast one record in wsh_delivery_details
555: -- is already purged. If yes, we do not allow reverting of the transaction.
556: cursor l_purge_details_csr (p_source_line_id IN NUMBER,
557: p_po_shipment_line_id IN NUMBER) is
558: select 'Y'

Line 559: from wsh_delivery_details

555: -- is already purged. If yes, we do not allow reverting of the transaction.
556: cursor l_purge_details_csr (p_source_line_id IN NUMBER,
557: p_po_shipment_line_id IN NUMBER) is
558: select 'Y'
559: from wsh_delivery_details
560: where source_line_id = p_source_line_id
561: and po_shipment_line_id = p_po_shipment_line_id
562: and source_code = 'PO'
563: and released_status = 'P'

Line 617: from wsh_delivery_details

613:
614: cursor l_delete_det_csr (p_source_line_id IN NUMBER,
615: p_po_shpmt_line_id IN NUMBER) is
616: select delivery_detail_id
617: from wsh_delivery_details
618: where source_line_id = p_source_line_id
619: and po_shipment_line_id = p_po_shpmt_line_id
620: and ( released_status = 'X'
621: or

Line 766: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.

762: IF l_debug_on THEN
763: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After deleting LPNs from WDA',SQL%ROWCOUNT);
764: END IF;
765:
766: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.
767: FORALL i IN l_delete_det_tbl.FIRST..l_delete_det_tbl.LAST
768: DELETE WSH_DELIVERY_DETAILS
769: WHERE delivery_detail_id = l_delete_det_tbl(i);
770:

Line 768: DELETE WSH_DELIVERY_DETAILS

764: END IF;
765:
766: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.
767: FORALL i IN l_delete_det_tbl.FIRST..l_delete_det_tbl.LAST
768: DELETE WSH_DELIVERY_DETAILS
769: WHERE delivery_detail_id = l_delete_det_tbl(i);
770:
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After deleting LPNs from WDD',SQL%ROWCOUNT);

Line 781: from wsh_delivery_details

777: /*
778: delete from wsh_delivery_assignments_v
779: where delivery_detail_id in
780: (select delivery_detail_id
781: from wsh_delivery_details
782: where source_line_id = l_source_line_id_tab(i)
783: and po_shipment_line_id = l_po_line_loc_id_tab(i)
784: and ( released_status = 'X'
785: or

Line 790: delete from wsh_delivery_details

786: (released_status = 'L' and received_quantity is null)
787: )
788: and routing_req_id is null);
789:
790: delete from wsh_delivery_details
791: where source_line_id = l_source_line_id_tab(i)
792: and po_shipment_line_id = l_po_line_loc_id_tab(i)
793: and ( released_status = 'X'
794: or

Line 840: update wsh_delivery_details

836: -- This update statement is added so that we can re-open the delivery
837: -- details that are closed just because PO may be closed. But we need to
838: -- re-open them as we do not know which delivery details will be used
839: -- when matching the receipt once again.
840: update wsh_delivery_details
841: set released_status = 'X'
842: where released_status = 'L'
843: and source_code = 'PO'
844: and po_shipment_line_id = l_po_line_loc_id_tab(i)

Line 856: -- Update of wsh_delivery_details where released_status

852: END IF;
853:
854: --
855: -- DBI Project
856: -- Update of wsh_delivery_details where released_status
857: -- are changed, call DBI API after the update.
858: -- This API will also check for DBI Installed or not
859: IF l_debug_on THEN
860: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API. delivery details l_detail_tab count :',l_detail_tab.COUNT);

Line 935: update wsh_delivery_details

931: IF l_debug_on THEN
932: WSH_DEBUG_SV.logmsg(l_module_name,'Before doing the update');
933: END IF;
934: FORALL i IN l_del_det_id_tab.FIRST..l_del_det_id_tab.LAST
935: update wsh_delivery_details
936: set returned_quantity = NULL,
937: returned_quantity2 = NULL,
938: received_quantity =NULL,
939: received_quantity2 = NULL,

Line 959: -- Update of wsh_delivery_details where released_status

955: WSH_DEBUG_SV.log(l_module_name,'l_num_warnings', l_num_warnings);
956: END IF;
957: --
958: -- DBI Project
959: -- Update of wsh_delivery_details where released_status
960: -- are changed, call DBI API after the update.
961: -- This API will also check for DBI Installed or not
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API. delivery details l_del_det_id_tab count :',l_del_det_id_tab.COUNT);

Line 987: update wsh_delivery_details

983: -- End of Code for DBI Project
984: --
985: -- Updating the released_status for the lpns if any are present
986: --
987: update wsh_delivery_details
988: set returned_quantity = NULL,
989: returned_quantity2 = NULL,
990: received_quantity =NULL,
991: received_quantity2 = NULL,

Line 1013: -- Update of wsh_delivery_details where released_status

1009: IF (l_cnt_det_id_tab.count > 0 ) THEN
1010: --{
1011: --
1012: -- DBI Project
1013: -- Update of wsh_delivery_details where released_status
1014: -- are changed, call DBI API after the update.
1015: -- This API will also check for DBI Installed or not
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API. delivery details l_del_det_id_tab count :',l_del_det_id_tab.COUNT);

Line 1738: from wsh_delivery_details wdd,

1734: wdd.organization_id,
1735: muom.unit_of_measure,
1736: wdd.src_requested_quantity,
1737: wdd.src_requested_quantity2
1738: from wsh_delivery_details wdd,
1739: mtl_units_of_measure muom
1740: where wdd.source_line_id = p_po_line_id
1741: and wdd.po_shipment_line_id = p_po_line_location_id
1742: and wdd.source_code = 'PO'

Line 1808: from wsh_delivery_details

1804: p_po_shpmt_line_id IN NUMBER,
1805: p_rcv_shpmt_line_id IN NUMBER) is
1806:
1807: select 'Y'
1808: from wsh_delivery_details
1809: where source_header_id = p_source_header_id
1810: and source_line_id = p_source_line_id
1811: and po_shipment_line_id = p_po_shpmt_line_id
1812: and rcv_shipment_line_id = p_rcv_shpmt_line_id

Line 2518: -- > we call WSH_DELIVERY_DETAILS_ACTIONS.

2514: -- > Call Revert_Details to revert the delivery details
2515: -- > Call Revert_Deliveries to rever the deliveries
2516: -- > If the revert_details API returns any records of delivery
2517: -- > details that need to be unassigned from the delivery, then
2518: -- > we call WSH_DELIVERY_DETAILS_ACTIONS.
2519: -- > Unassign_Multiple_Details. We need to do this only for
2520: -- > delivery details that ship_from_location_id as -1.
2521: -- > Then we call WSH_PO_CMG_PVT.Reapprove_PO as the
2522: -- > lines that have been re-opened need to be updated with the

Line 2764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

2760: --
2761: -- Debug Statements
2762: --
2763: IF l_debug_on THEN
2764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2765: END IF;
2766: --
2767: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
2768: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(

Line 2768: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(

2764: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2765: END IF;
2766: --
2767: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
2768: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
2769: P_REC_OF_DETAIL_IDS => l_unassign_det_id_tab,
2770: P_FROM_delivery => 'Y',
2771: P_FROM_container => 'N',
2772: x_return_status => l_return_status,