APPS.RCV_ACCRUALACCOUNTING_GRP SQL Statements

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

Line: 174

         SELECT        nvl(b.process_enabled_flag, 'N')
         INTO          l_process_enabled_flag
         FROM          po_line_locations_all a,
                       mtl_parameters b
         WHERE         a.line_location_id = p_po_line_location_id
         AND           b.organization_id = a.ship_to_organization_id;

Line: 243

	SELECT 	count(*)
	INTO   	l_rae_count
	FROM 	rcv_accounting_events RAE
	WHERE 	rcv_transaction_id = p_rcv_transaction_id;

Line: 272

        SELECT lcm_flag
          INTO l_lcm_enabled
          FROM po_line_locations_all
         WHERE line_location_id = p_po_line_location_id;