APPS.OE_CUSTACCEPTREP_PVT SQL Statements

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

Line: 111

  SELECT TO_CHAR(p_date, 'YYYY-MM-DD')
  INTO   l_xsd_date_string
  FROM   DUAL;

Line: 168

select meaning into l_sorted_by
from oe_lookups
where lookup_type='OECARR_ORDER_BY'
and lookup_code=g_sorted_by;

Line: 178

 select meaning into l_acceptance_status
 from oe_lookups
 where lookup_type='OECARR_ACC_STATUS'
 and lookup_code = g_acceptance_status;

Line: 187

  select meaning into l_item_display
	from OE_LOOKUPS
	where lookup_type = 'ITEM_DISPLAY_CODE'
	and LOOKUP_CODE=g_item_display;

Line: 197

  select name into l_order_type_low
	from OE_ORDER_TYPES_V
	where order_type_id = g_order_type_low ;

Line: 203

  select name into l_order_type_high
	from OE_ORDER_TYPES_V
	where order_type_id = g_order_type_high ;

Line: 738

l_cust_cursor_query VARCHAR2(15000) := 'SELECT DISTINCT hp.party_name, '||
                                         '       hca.account_number, '||
                                         '       hca.cust_account_id '||
					 'FROM   hz_parties hp, '||
					 '       hz_cust_accounts_all hca, '||
					 '       oe_order_headers_all oha, '||
					 '       oe_order_lines_all   oln, '||
					 '       oe_transaction_types_all ota '||
					 'WHERE  hp.party_id = hca.party_id '||
					 'AND    hca.cust_account_id = oha.sold_to_org_id '||
					 'AND    oha.header_id = oln.header_id '||
					 'AND    oha.order_type_id = ota.transaction_type_id ';

Line: 753

l_ord_cursor_query VARCHAR2(15000) := 'SELECT distinct oha.order_number,'||
                                        '       oha.header_id,'||
					'       oha.ordered_date,'||
					'	oha.cust_po_number,'||
					'	ota.order_category_code,'||
					'       rsa.name, '||
					'       oha.TRANSACTIONAL_CURR_CODE, '||
					'	oha.conversion_type_code, '||
					'	oha.conversion_rate '||
					'FROM   oe_order_headers_all oha, '||
					'       oe_order_lines_all oln, '||
					'       oe_transaction_types_all ota, '||
					'	ra_salesreps_all rsa '||
					'WHERE  oha.order_type_id = ota.transaction_type_id '||
					'AND    oha.header_id = oln.header_id ' ||
					'AND    oha.salesrep_id = rsa.salesrep_id ';

Line: 770

l_line_cursor_query VARCHAR2(15000) := 'SELECT oln.line_number,'||
                                         '       oln.ordered_item,'||
					 '	 oln.user_item_description,'||
					 '       msi.concatenated_segments,'||
					 '       msi.description,'||
					 '	 oln.ordered_quantity, '||
					 '	 oln.ordered_quantity * oln.unit_selling_price ordered_value, '||
					 '       oln.fulfilled_quantity,'||
					 '       oln.fulfilled_quantity * oln.unit_selling_price fulfilled_value,'||
					 '	 oln.shipped_quantity,'||
					 '       oln.shipped_quantity * oln.unit_selling_price shipped_value, '||
					 '       oln.order_quantity_uom,'||
					 '	 oln.accepted_quantity,'||
					 '       oln.accepted_quantity * oln.unit_selling_price acceptance_value '||
					 'FROM   oe_order_lines_all oln, '||
					 '       mtl_system_items_b_kfv msi '||
					 'WHERE  msi.inventory_item_id = oln.inventory_item_id '||
					 'AND    msi.organization_id = oln.ship_from_org_id ';

Line: 1256

l_curr_cursor_query  VARCHAR2(15000)  := 'SELECT distinct oha.TRANSACTIONAL_CURR_CODE   '||
					 'FROM   oe_order_headers_all oha,		'||
					 '	 oe_order_lines_all  oln,		'||
					 '	 oe_transaction_types_all ota,		'||
					 '	 ra_salesreps_all rsa			'||
					 'WHERE  oha.order_type_id = ota.transaction_type_id	'||
					 'AND    oha.header_id = oln.header_id '||
					 'AND    oha.salesrep_id = rsa.salesrep_id ';

Line: 1265

l_cust_soldto_cursor_query VARCHAR2(15000) := 'SELECT DISTINCT hca.cust_account_id '||
					 'FROM   hz_parties hp, '||
					 '       hz_cust_accounts_all hca, '||
					 '       oe_order_headers_all oha, '||
					 '       oe_order_lines_all   oln, '||
					 '       oe_transaction_types_all ota '||
					 'WHERE  hp.party_id = hca.party_id '||
					 'AND    hca.cust_account_id = oha.sold_to_org_id '||
					 'AND    oha.header_id = oln.header_id '||
					 'AND    oha.order_type_id = ota.transaction_type_id ';

Line: 1296

    SELECT name
    INTO   g_operating_unit
    FROM   hr_organization_units
    WHERE  organization_id = g_org_id;

Line: 1327

	SELECT meaning into g_func_currency_desc
	FROM FND_LOOKUPS
	WHERE lookup_type = 'YES_NO'
	AND lookup_code = p_func_currency;

Line: 1343

   SELECT curr.currency_code
   INTO   g_func_currency
   FROM   fnd_currencies curr,
          gl_sets_of_books sob
   WHERE  curr.enabled_flag ='Y'
   AND    sob.set_of_books_id = (select FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')
                                 from dual)
   AND    curr.currency_code = sob.currency_code;