APPS.GRP_DISCOUNTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

                 SELECT 'Y'
                 FROM  mtl_default_category_sets MTDCS
			  , mtl_category_set_valid_cats MCSV
			  , mtl_categories MC
			  ,MTL_ITEM_CATEGORIES MTC
                 WHERE  MTDCS.functional_area_id = 7
                 AND    MTC.category_set_id = MTDCS.category_set_id
                 AND    MTC.INVENTORY_ITEM_ID = TO_CHAR( Inv_Item_Id )
			  AND    MCSV.category_set_id = MTC.category_set_id
			  AND    MCSV.category_id = MTC.category_id
			  AND    MCSV.category_id = MC.category_id
			  AND    sysdate < nvl(MC.disable_date, sysdate+1)
                 AND    MTC.CATEGORY_ID = to_number(ENT_VAL);

Line: 24

                 SELECT 'Y'
                 FROM mtl_default_category_sets MTDCS
			  , mtl_category_set_valid_cats MCSV
			  , mtl_categories MC
                 	  , MTL_ITEM_CATEGORIES MTC
                 WHERE  MTDCS.functional_area_id = 7
                 AND    MTC.category_set_id = MTDCS.category_set_id
                 AND    MTC.INVENTORY_ITEM_ID = TO_CHAR( Inv_Item_Id )
			  AND    MCSV.category_set_id = MTC.category_set_id
			  AND    MCSV.category_id = MTC.category_id
			  AND    MCSV.category_id = MC.category_id
			  AND    sysdate < nvl(MC.disable_date, sysdate+1)
                 AND    MTC.ORGANIZATION_ID = OrgId
                 AND    MTC.CATEGORY_ID = to_number(ENT_VAL);