APPS.WSH_MAPPING_DATA dependencies on WSH_SERIAL_NUMBERS

Line 882: FROM wsh_serial_numbers

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

Line 887: FROM wsh_serial_numbers

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

Line 1696: FROM wsh_serial_numbers

1692:
1693: -- Distributed - TPW Changes
1694: CURSOR get_rowid_count(cp_delivery_detail_id NUMBER) IS
1695: SELECT rowidtochar(min(rowid)),count(*),sum(quantity)
1696: FROM wsh_serial_numbers
1697: WHERE delivery_detail_id = cp_delivery_detail_id;
1698:
1699: CURSOR get_wsn_qty(cp_wsn_rowid VARCHAR2) IS
1700: SELECT quantity

Line 1701: FROM wsh_serial_numbers

1697: WHERE delivery_detail_id = cp_delivery_detail_id;
1698:
1699: CURSOR get_wsn_qty(cp_wsn_rowid VARCHAR2) IS
1700: SELECT quantity
1701: FROM wsh_serial_numbers
1702: WHERE rowidtochar(rowid) = cp_wsn_rowid;
1703:
1704: CURSOR get_msnt_rowid_count(cp_delivery_detail_id NUMBER) IS
1705: SELECT rowidtochar(min(rowid)),count(*),sum(to_number(SERIAL_PREFIX))