APPS.OE_RMA_QUERY_PRICE SQL Statements

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

Line: 19

  SELECT NVL( SUM( PERCENT ), 0 )
  INTO   L_PRICE_ADJUSTMENTS_TOTAL
  FROM   SO_PRICE_ADJUSTMENTS
  WHERE  (HEADER_ID = P_HEADER_ID
    AND   LINE_ID IS NULL)
     OR   LINE_ID = P_LINE_ID
     OR  (HEADER_ID = P_REF_ORD_HEADER_ID
          AND LINE_ID IS NULL);

Line: 55

  SELECT SO_LINES.PRICE_LIST_ID
  ,      SO_LINES.TERMS_ID
  ,      SOPLS.ROUNDING_FACTOR
  INTO   P_PRICE_LIST_ID
  ,      P_TERMS_ID
  ,      P_ROUNDING_FACTOR
  FROM   SO_PRICE_LISTS SOPLS
  ,      SO_LINES
  WHERE  SO_LINES.PRICE_LIST_ID = SOPLS.PRICE_LIST_ID
  AND    SO_LINES.LINE_ID = P_LINE_ID;

Line: 98

  SELECT PRICING_CONTEXT,
	 PRICING_ATTRIBUTE1,
	 PRICING_ATTRIBUTE2,
	 PRICING_ATTRIBUTE3,
	 PRICING_ATTRIBUTE4,
	 PRICING_ATTRIBUTE5,
	 PRICING_ATTRIBUTE6,
	 PRICING_ATTRIBUTE7,
	 PRICING_ATTRIBUTE8,
	 PRICING_ATTRIBUTE9,
	 PRICING_ATTRIBUTE10,
	 PRICING_ATTRIBUTE11,
	 PRICING_ATTRIBUTE12,
	 PRICING_ATTRIBUTE13,
	 PRICING_ATTRIBUTE14,
	 PRICING_ATTRIBUTE15
  INTO	 L_PRICING_CONTEXT,
	 L_PRICING_ATTRIBUTE1,
	 L_PRICING_ATTRIBUTE2,
	 L_PRICING_ATTRIBUTE3,
	 L_PRICING_ATTRIBUTE4,
	 L_PRICING_ATTRIBUTE5,
	 L_PRICING_ATTRIBUTE6,
	 L_PRICING_ATTRIBUTE7,
	 L_PRICING_ATTRIBUTE8,
	 L_PRICING_ATTRIBUTE9,
	 L_PRICING_ATTRIBUTE10,
	 L_PRICING_ATTRIBUTE11,
	 L_PRICING_ATTRIBUTE12,
	 L_PRICING_ATTRIBUTE13,
	 L_PRICING_ATTRIBUTE14,
	 L_PRICING_ATTRIBUTE15
  FROM   SO_LINES
  WHERE   LINE_ID = L_LINK_TO_LINE_ID;