APPS.WSH_MAPPING_DATA dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1706: FROM mtl_serial_numbers_temp

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))
1706: FROM mtl_serial_numbers_temp
1707: WHERE transaction_temp_id IN
1708: (SELECT transaction_temp_id
1709: FROM WSH_DELIVERY_DETAILS
1710: WHERE DELIVERY_DETAIL_ID = cp_delivery_detail_id

Line 1715: FROM mtl_serial_numbers_temp

1711: AND SOURCE_CODE = 'OE');
1712:
1713: CURSOR get_msnt_qty(cp_wsn_rowid VARCHAR2) IS
1714: SELECT to_number(SERIAL_PREFIX)
1715: FROM mtl_serial_numbers_temp
1716: WHERE rowidtochar(rowid) = cp_wsn_rowid;
1717:
1718: l_wsn_rowid VARCHAR2(100);
1719: l_wsn_count NUMBER;