APPS.PV_ENRL_REQUEST_ORDER_PUB SQL Statements

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

Line: 36

       select h.payment_type_code , h.cust_po_number
       into v_payment_type_code, v_po_number
       from oe_order_headers_all h
       where h.header_id = p_order_header_id;

Line: 43

		select meaning
		into v_payment_type
		from pv_lookups
		where lookup_type ='PV_PAYMENT_TYPE'
		and lookup_code = 'INVOICE';

Line: 49

	        select meaning
		into v_payment_type
		from pv_lookups
		where lookup_type ='PV_PAYMENT_TYPE'
		and lookup_code = v_payment_type_code;

Line: 61

	   select meaning
	   into v_payment_type
	   from fnd_lookup_values_vl
	   where lookup_type ='PV_PAYMENT_TYPE'
	   and lookup_code = 'PURCHASE_ORDER';

Line: 69

               select meaning
	       into v_payment_type
	       from fnd_lookup_values_vl
	       where lookup_type ='PV_PAYMENT_TYPE'
	       and lookup_code = 'WIRE_TRANSFER';

Line: 75

              select meaning
	      into v_payment_type
	      from oe_lookups
	      where lookup_type = 'PAYMENT TYPE'
	      and lookup_code = v_payment_type_code;

Line: 107

      SELECT NVL(SUM(ARPS.AMOUNT_DUE_REMAINING),0), FCV.NAME
      into x_invoice_balance, x_invoice_currency
      FROM AR_PAYMENT_SCHEDULES_ALL ARPS, RA_CUSTOMER_TRX_LINES_ALL RCTL,
           OE_ORDER_LINES_ALL OOLA, FND_CURRENCIES_VL FCV
      WHERE  OOLA.HEADER_ID = p_order_header_id
      AND RCTL.INTERFACE_LINE_ATTRIBUTE6  = to_char(OOLA.LINE_ID)
      AND RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
      AND  RCTL.CUSTOMER_TRX_ID = ARPS.CUSTOMER_TRX_ID
      AND ARPS.CLASS = 'INV'
      AND  ARPS.INVOICE_CURRENCY_CODE = FCV.CURRENCY_CODE
      group by  RCTL.CUSTOMER_TRX_ID, FCV.NAME ;

Line: 138

    SELECT NVL(SUM(ARPS.AMOUNT_DUE_REMAINING),0), FCV.name, RCT.TRX_NUMBER
      into x_invoice_balance, x_invoice_currency, x_invoice_number
      FROM AR_PAYMENT_SCHEDULES_ALL ARPS, RA_CUSTOMER_TRX_LINES_ALL RCTL,
      FND_CURRENCIES_VL FCV, RA_CUSTOMER_TRX_ALL RCT
      WHERE  RCTL.INTERFACE_LINE_ATTRIBUTE6  = p_order_line_id
      AND RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
      AND  RCTL.CUSTOMER_TRX_ID = ARPS.CUSTOMER_TRX_ID
      AND  ARPS.CLASS = 'INV'
      AND  ARPS.INVOICE_CURRENCY_CODE = FCV.CURRENCY_CODE
      AND RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID
      group by  RCTL.CUSTOMER_TRX_ID, FCV.name, RCT.TRX_NUMBER;