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.INV_CYC_LOVS dependencies on WMS_LOADED_QUANTITIES_V

Line 4658: FROM WMS_LOADED_QUANTITIES_V

4654: SELECT NVL ( SUM ( quantity ), 0 )
4655: , NVL ( SUM ( secondary_quantity ), 0 ) -- nsinghi bug#6052831
4656: INTO l_loaded_sys_qty
4657: , l_loaded_sec_sys_qty -- nsinghi bug#6052831
4658: FROM WMS_LOADED_QUANTITIES_V
4659: WHERE inventory_item_id = l_item_id
4660: AND organization_id = l_org_id
4661: AND NVL ( containerized_flag, 2 ) = 2
4662: AND subinventory_code = l_sub

Line 4672: -- row in wms_loaded_quantities_v which has these fields populated for the

4668: AND qty_type = 'LOADED'
4669: AND lpn_id IS NULL
4670: AND content_lpn_id IS NULL; -- bug 2640378
4671: -- need lpn_id and content lpn id is null because there could be a
4672: -- row in wms_loaded_quantities_v which has these fields populated for the
4673: -- same items/sub.. combination and here we are processing loose
4674:
4675: IF ( l_debug = 1 ) THEN
4676: print_debug ( 'Loaded qty is ' || l_loaded_sys_qty );

Line 5161: wms_loaded_quantities_v wl

5157: -- just check with msnt
5158: SELECT COUNT ( * )
5159: INTO l_serial_count
5160: FROM mtl_serial_numbers_temp s,
5161: wms_loaded_quantities_v wl
5162: WHERE s.transaction_temp_id = wl.transaction_temp_id
5163: AND wl.inventory_item_id = p_inventory_item_id -- Bug 13652899
5164: AND wl.organization_id = p_organization_id -- Bug 13796753
5165: AND p_serial_number BETWEEN s.fm_serial_number

Line 5178: wms_loaded_quantities_v wl,

5174: ELSE -- have to join mtlt also
5175: SELECT COUNT ( * )
5176: INTO l_serial_count
5177: FROM mtl_serial_numbers_temp s,
5178: wms_loaded_quantities_v wl,
5179: mtl_transaction_lots_temp l
5180: WHERE wl.transaction_temp_id = l.transaction_temp_id
5181: AND wl.organization_id = p_organization_id -- Bug 13796753
5182: AND s.transaction_temp_id = l.serial_transaction_temp_id

Line 5200: wms_loaded_quantities_v wl

5196: -- Modified for opp cyc count 9248808
5197: SELECT COUNT ( * )
5198: INTO l_serial_count
5199: FROM mtl_serial_numbers s,
5200: wms_loaded_quantities_v wl
5201: WHERE s.lpn_id = p_lpn_id
5202: -- AND NVL ( wl.content_lpn_id, NVL ( wl.lpn_id, -1 ) ) = s.lpn_id -- Modified for opp cyc count 9248808
5203: AND NVL ( wl.content_lpn_id, -1 ) = s.lpn_id
5204: AND s.serial_number = p_serial_number

Line 7395: FROM WMS_LOADED_QUANTITIES_V WLQV

7391: --Bug#4891370.Added new cursor to query loaded quantity from LPN.
7392: CURSOR lpn_loaded_quantity_cur(p_inventory_item_id NUMBER,p_organization_id NUMBER,p_lpn_id NUMBER)
7393: IS
7394: SELECT NVL ( SUM ( quantity ), 0 )
7395: FROM WMS_LOADED_QUANTITIES_V WLQV
7396: WHERE WLQV.inventory_item_id = p_inventory_item_id
7397: AND WLQV.organization_id = p_organization_id
7398: AND (lpn_id = p_lpn_id OR content_lpn_id = p_lpn_id )
7399: AND qty_type = 'LOADED';

Line 9110: FROM WMS_LOADED_QUANTITIES_V

9106: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
9107:
9108: SELECT NVL ( SUM ( quantity ), 0 )
9109: INTO l_loaded_sys_qty
9110: FROM WMS_LOADED_QUANTITIES_V
9111: WHERE inventory_item_id = p_inventory_item_id
9112: AND organization_id = p_organization_id
9113: AND NVL ( containerized_flag, 2 ) = 2
9114: AND subinventory_code = p_subinventory

Line 9155: FROM wms_loaded_quantities_v

9151: AND NVL ( serial_summary_entry, 2 ) = 2;
9152:
9153: SELECT NVL ( SUM ( quantity ), 0 )
9154: INTO l_loaded_sys_qty
9155: FROM wms_loaded_quantities_v
9156: WHERE NVL ( lpn_id, NVL ( content_lpn_id, -1 ) ) = p_parent_lpn_id
9157: and inventory_item_id = p_inventory_item_id
9158: and organization_id = p_organization_id;
9159:

Line 9196: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl

9192: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
9193:
9194: select count(*)
9195: into l_loaded_sys_qty
9196: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl
9197: where ((msnt.transaction_temp_id = wl.transaction_temp_id
9198: and wl.lot_number is null) or
9199: (msnt.transaction_temp_id = wl.serial_transaction_temp_id
9200: and wl.lot_number is not null)

Line 9233: from mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, wms_loaded_quantities_v wl

9229:
9230: --Bug#12645638
9231: SELECT Count(DISTINCT msn.serial_number)
9232: into l_loaded_sys_qty
9233: from mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, wms_loaded_quantities_v wl
9234: where msn.lpn_id = nvl(wl.content_lpn_id,nvl(wl.lpn_id,-1))
9235: AND ((msnt.transaction_temp_id = wl.transaction_temp_id and wl.lot_number is null)
9236: or (msnt.transaction_temp_id = wl.serial_transaction_temp_id and wl.lot_number is not null))
9237: and wl.containerized_flag = 1

Line 9252: from mtl_serial_numbers msn, wms_loaded_quantities_v wl

9248: AND NVL ( wl.revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
9249:
9250: /*SELECT SUM(NVL( wl.quantity,0)) --9452528
9251: into l_loaded_sys_qty
9252: from mtl_serial_numbers msn, wms_loaded_quantities_v wl
9253: where msn.lpn_id = nvl(wl.content_lpn_id,nvl(wl.lpn_id,-1))
9254: and wl.containerized_flag = 1
9255: and msn.inventory_item_id = wl.inventory_item_id
9256: and msn.current_organization_id = wl.ORGANIZATION_ID