APPS.WSH_MAPPING_DATA dependencies on WSH_SERIAL_NUMBERS

Line 880: FROM wsh_serial_numbers

876: ORDER BY cnt desc;
877:
878: CURSOR get_rowid_count(cp_delivery_detail_id NUMBER) IS
879: SELECT rowidtochar(min(rowid)),count(*),sum(quantity)
880: FROM wsh_serial_numbers
881: WHERE delivery_detail_id = cp_delivery_detail_id;
882:
883: CURSOR get_wsn_qty(cp_wsn_rowid VARCHAR2) IS
884: SELECT quantity

Line 885: FROM wsh_serial_numbers

881: WHERE delivery_detail_id = cp_delivery_detail_id;
882:
883: CURSOR get_wsn_qty(cp_wsn_rowid VARCHAR2) IS
884: SELECT quantity
885: FROM wsh_serial_numbers
886: WHERE rowidtochar(rowid) = cp_wsn_rowid;
887:
888: --bug 3920178 {
889: cursor l_site_use_loc_csr(p_site_use_id IN NUMBER) is