

nsert into aw_products values (200041, 'RR', 'Rice Monthly Research Report', 1, 1, 'MONTHLY', 'Y')
nsert into aw_products values (200042, 'RR', 'Wheat Monthly Research Report', 1, 2, 'MONTHLY', 'Y')
nsert into aw_products values (200043, 'RR', 'Maize Monthly Research Report', 1, 3, 'MONTHLY', 'Y')
nsert into aw_products values (200044, 'RR', 'Pulses Monthly Research Report', 2, 0, 'MONTHLY', 'Y')
nsert into aw_products values (200045, 'RR', 'Veg Oil Monthly Research Report', 3, 0, 'MONTHLY', 'Y')
nsert into aw_products values (200046, 'RR', 'Oil Seeds Monthly Research Report', 4, 0, 'MONTHLY', 'Y')
nsert into aw_products values (200047, 'RR', 'Oil Meals Monthly Research Report', 5, 0, 'MONTHLY', 'Y')
nsert into aw_products values (200048, 'RR', 'Sugar Monthly Research Report', 6, 0, 'MONTHLY', 'Y')
nsert into aw_products values (200049, 'RR', 'Cotton Monthly Research Report', 7, 24, 'MONTHLY', 'Y')
nsert into aw_products values (200050, 'RR', 'Guar Monthly Research Report', 8, 0, 'MONTHLY', 'Y')
nsert into aw_products values (200051, 'RR', 'Spices Monthly Research Report', 9, 0, 'MONTHLY', 'Y')


nsert into aw_packages values (200044, 'Rice Monthly Research Report', 'RR')
nsert into aw_packages values (200045, 'Wheat Monthly Research Report', 'RR')
nsert into aw_packages values (200046, 'Maize Monthly Research Report', 'RR')
nsert into aw_packages values (200047, 'Pulses Monthly Research Report', 'RR')
nsert into aw_packages values (200048, 'Veg Oil Monthly Research Report', 'RR')
nsert into aw_packages values (200049, 'Oil Seeds Monthly Research Report', 'RR')
nsert into aw_packages values (200050, 'Oil Meals Monthly Research Report', 'RR')
nsert into aw_packages values (200051, 'Sugar Monthly Research Report', 'RR')
nsert into aw_packages values (200052, 'Cotton Monthly Research Report', 'RR')
nsert into aw_packages values (200053, 'Guar Monthly Research Report', 'RR')
nsert into aw_packages values (200054, 'Spices Monthly Research Report', 'RR')

select * from aw_product_package where package_id=8

nsert into aw_product_package values (200041, 8)
nsert into aw_product_package values (200042, 8)
nsert into aw_product_package values (200043, 8)
nsert into aw_product_package values (200044, 8)
nsert into aw_product_package values (200045, 8)
nsert into aw_product_package values (200046, 8)
nsert into aw_product_package values (200047, 8)
nsert into aw_product_package values (200048, 8)
nsert into aw_product_package values (200049, 8)
nsert into aw_product_package values (200050, 8)
nsert into aw_product_package values (200051, 8)
