APPS.OE_FREIGHT_RATING_UTIL SQL Statements

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

Line: 126

          SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
	  INTO l_cost_amount
	  FROM OE_PRICE_ADJUSTMENTS
	  WHERE LINE_ID = l_line_rec.line_id
	  AND LIST_LINE_TYPE_CODE = 'COST'
	  AND CHARGE_TYPE_CODE = p_cost_type_code
          AND nvl(ESTIMATED_FLAG, 'N') <> 'Y';

Line: 140

          SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
	  INTO l_cost_amount
	  FROM OE_PRICE_ADJUSTMENTS
	  WHERE LINE_ID = l_line_rec.line_id
	  AND LIST_LINE_TYPE_CODE = 'COST'
	  AND CHARGE_TYPE_CODE = p_cost_type_code
          AND ESTIMATED_FLAG = 'Y';

Line: 218

           SELECT  list_line_type_code
           INTO   l_list_line_type_code
           FROM   oe_price_adjustments
           WHERE  header_id = p_key
           AND    list_header_id = p_key * (-1)
           AND    list_line_type_code = 'OM_CALLED_FREIGHT_RATES'
           AND    rownum = 1;

Line: 323

          SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
	  INTO l_cost_amount
	  FROM OE_PRICE_ADJUSTMENTS
	  WHERE LINE_ID = l_line_rec.line_id
	  AND LIST_LINE_TYPE_CODE = 'COST'
	  AND CHARGE_TYPE_CODE = p_cost_type_code
          AND ESTIMATED_FLAG = 'Y';

Line: 378

    select oe_price_adjustments_s.nextval
    into   l_price_adjustment_id
    from   dual;

Line: 382

    INSERT INTO oe_price_adjustments
           (PRICE_ADJUSTMENT_ID
           ,HEADER_ID
           ,LINE_ID
           ,PRICING_PHASE_ID
           ,LIST_LINE_TYPE_CODE
           ,LIST_HEADER_ID
           ,LIST_LINE_ID
           ,ADJUSTED_AMOUNT
           ,AUTOMATIC_FLAG
           ,UPDATED_FLAG
           ,APPLIED_FLAG
           ,CREATION_DATE
           ,CREATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATED_BY
           )
    VALUES
          (l_price_adjustment_id
           ,p_header_id
           ,NULL
           ,-1
           ,'OM_CALLED_FREIGHT_RATES'
           ,-1*p_header_id
           ,NULL
           ,-1
           ,'N'
           ,'Y'
           ,NULL
           ,sysdate
           ,1
           ,sysdate
           ,1
          );

Line: 463

   SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
   INTO l_cost_amount
   FROM OE_PRICE_ADJUSTMENTS
   WHERE LINE_ID = l_line_rec.line_id
   AND LIST_LINE_TYPE_CODE = 'COST'
   AND CHARGE_TYPE_CODE = p_cost_type_code
   AND ESTIMATED_FLAG = 'Y';