APPS.INV_MWB_LOCATION_TREE dependencies on MTL_SERIAL_NUMBERS

Line 2581: serial mtl_serial_numbers.serial_number%TYPE;

2577: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
2578: , x_tbl_index IN OUT NOCOPY NUMBER
2579: )
2580: IS
2581: serial mtl_serial_numbers.serial_number%TYPE;
2582: loc_control NUMBER;
2583: serial_control NUMBER;
2584: from_receiving NUMBER;
2585: str_query VARCHAR2(4000);

Line 3228: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');

3224: '''Ea''';
3225:
3226: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
3227:
3228: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
3229:
3230: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
3231: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
3232: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');

Line 3353: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');

3349: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
3350: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
3351: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
3352:
3353: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
3354: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
3355:
3356: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
3357: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN