APPS.INV_MWB_LOCATION_TREE dependencies on MTL_SERIAL_NUMBERS

Line 2287: serial mtl_serial_numbers.serial_number%TYPE;

2283: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
2284: , x_tbl_index IN OUT NOCOPY NUMBER
2285: )
2286: IS
2287: serial mtl_serial_numbers.serial_number%TYPE;
2288: loc_control NUMBER;
2289: serial_control NUMBER;
2290: from_receiving NUMBER;
2291: str_query VARCHAR2(4000);

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

2903: '''Ea''';
2904:
2905: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
2906:
2907: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
2908:
2909: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
2910: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
2911: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id', 'ONHAND');

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

3028: inv_mwb_query_manager.add_group_clause('msn.inventory_item_id' , 'ONHAND');
3029: inv_mwb_query_manager.add_group_clause('msn.current_organization_id', 'ONHAND');
3030: inv_mwb_query_manager.add_group_clause('''Ea''', 'ONHAND');
3031:
3032: inv_mwb_query_manager.add_from_clause('mtl_serial_numbers msn', 'ONHAND');
3033: inv_mwb_query_manager.add_where_clause('msn.current_status = 3', 'ONHAND');
3034:
3035: IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
3036: OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN