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 4331: FROM WMS_LOADED_QUANTITIES_V

4327: AND NVL ( cost_group_id, -9 ) = NVL ( l_cost_group_id, -9 );
4328:
4329: SELECT NVL ( SUM ( quantity ), 0 )
4330: INTO l_loaded_sys_qty
4331: FROM WMS_LOADED_QUANTITIES_V
4332: WHERE inventory_item_id = l_item_id
4333: AND organization_id = l_org_id
4334: AND NVL ( containerized_flag, 2 ) = 2
4335: AND subinventory_code = l_sub

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

4341: AND qty_type = 'LOADED'
4342: AND lpn_id IS NULL
4343: AND content_lpn_id IS NULL; -- bug 2640378
4344: -- need lpn_id and content lpn id is null because there could be a
4345: -- row in wms_loaded_quantities_v which has these fields populated for the
4346: -- same items/sub.. combination and here we are processing loose
4347:
4348: IF ( l_debug = 1 ) THEN
4349: print_debug ( 'Loaded qty is ' || l_loaded_sys_qty );

Line 4664: FROM WMS_LOADED_QUANTITIES_V

4660: SELECT NVL ( SUM ( quantity ), 0 )
4661: , NVL ( SUM ( secondary_quantity ), 0 ) -- nsinghi bug#6052831
4662: INTO l_loaded_sys_qty
4663: , l_loaded_sec_sys_qty -- nsinghi bug#6052831
4664: FROM WMS_LOADED_QUANTITIES_V
4665: WHERE inventory_item_id = l_item_id
4666: AND organization_id = l_org_id
4667: AND NVL ( containerized_flag, 2 ) = 2
4668: AND subinventory_code = l_sub

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

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

Line 5095: wms_loaded_quantities_v wl

5091: -- just check with msnt
5092: SELECT COUNT ( * )
5093: INTO l_serial_count
5094: FROM mtl_serial_numbers_temp s,
5095: wms_loaded_quantities_v wl
5096: WHERE s.transaction_temp_id = wl.transaction_temp_id
5097: AND p_serial_number BETWEEN s.fm_serial_number
5098: AND s.to_serial_number;
5099:

Line 5111: wms_loaded_quantities_v wl,

5107: ELSE -- have to join mtlt also
5108: SELECT COUNT ( * )
5109: INTO l_serial_count
5110: FROM mtl_serial_numbers_temp s,
5111: wms_loaded_quantities_v wl,
5112: mtl_transaction_lots_temp l
5113: WHERE wl.transaction_temp_id = l.transaction_temp_id
5114: AND s.transaction_temp_id = l.serial_transaction_temp_id
5115: AND p_serial_number BETWEEN fm_serial_number

Line 5130: wms_loaded_quantities_v wl

5126: ELSE -- lpn is not null
5127: SELECT COUNT ( * )
5128: INTO l_serial_count
5129: FROM mtl_serial_numbers s,
5130: wms_loaded_quantities_v wl
5131: WHERE s.lpn_id = p_lpn_id
5132: AND NVL ( wl.content_lpn_id, NVL ( wl.lpn_id, -1 ) ) = s.lpn_id
5133: AND s.serial_number = p_serial_number
5134: AND s.current_organization_id = p_organization_id

Line 7279: FROM WMS_LOADED_QUANTITIES_V WLQV

7275: --Bug#4891370.Added new cursor to query loaded quantity from LPN.
7276: CURSOR lpn_loaded_quantity_cur(p_inventory_item_id NUMBER,p_organization_id NUMBER,p_lpn_id NUMBER)
7277: IS
7278: SELECT NVL ( SUM ( quantity ), 0 )
7279: FROM WMS_LOADED_QUANTITIES_V WLQV
7280: WHERE WLQV.inventory_item_id = p_inventory_item_id
7281: AND WLQV.organization_id = p_organization_id
7282: AND (lpn_id = p_lpn_id OR content_lpn_id = p_lpn_id )
7283: AND qty_type = 'LOADED';

Line 8885: FROM WMS_LOADED_QUANTITIES_V

8881: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
8882:
8883: SELECT NVL ( SUM ( quantity ), 0 )
8884: INTO l_loaded_sys_qty
8885: FROM WMS_LOADED_QUANTITIES_V
8886: WHERE inventory_item_id = p_inventory_item_id
8887: AND organization_id = p_organization_id
8888: AND NVL ( containerized_flag, 2 ) = 2
8889: AND subinventory_code = p_subinventory

Line 8930: FROM wms_loaded_quantities_v

8926: AND NVL ( serial_summary_entry, 2 ) = 2;
8927:
8928: SELECT NVL ( SUM ( quantity ), 0 )
8929: INTO l_loaded_sys_qty
8930: FROM wms_loaded_quantities_v
8931: WHERE NVL ( lpn_id, NVL ( content_lpn_id, -1 ) ) = p_parent_lpn_id
8932: and inventory_item_id = p_inventory_item_id
8933: and organization_id = p_organization_id;
8934:

Line 8971: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl

8967: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
8968:
8969: select count(*)
8970: into l_loaded_sys_qty
8971: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl
8972: where ((msnt.transaction_temp_id = wl.transaction_temp_id
8973: and wl.lot_number is null) or
8974: (msnt.transaction_temp_id = wl.serial_transaction_temp_id
8975: and wl.lot_number is not null)

Line 9007: from mtl_serial_numbers msn, wms_loaded_quantities_v wl

9003: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
9004:
9005: select distinct wl.quantity
9006: into l_loaded_sys_qty
9007: from mtl_serial_numbers msn, wms_loaded_quantities_v wl
9008: where msn.lpn_id = nvl(wl.content_lpn_id,nvl(wl.lpn_id,-1))
9009: and wl.containerized_flag = 1
9010: and msn.inventory_item_id = wl.inventory_item_id
9011: and msn.current_organization_id = wl.ORGANIZATION_ID