APPS.ICX_GET SQL Statements

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

Line: 18

  SELECT action_date
  INTO   x_action_date
  FROM   PO_ACTION_HISTORY
  WHERE  object_id = x_object_id
  AND    object_type_code like x_object_type_code
  AND    object_sub_type_code like x_subtype_code
  AND	 action_code like x_action_code
  AND    not exists
           ( SELECT action_date
             FROM   PO_ACTION_HISTORY
             WHERE  object_id = x_object_id
             AND    object_type_code =   x_object_type_code
             AND    object_sub_type_code = x_subtype_code
             AND    action_code is null);

Line: 49

 select	count(distinct pol.item_id)
 into	x_item_count
 from 	po_headers poh
	, po_lines pol
 where 	poh.po_header_id = pol.po_header_id
 and 	((poh.type_lookup_code = 'QUOTATION' and poh.status_lookup_code = 'A')
	 or (poh.type_lookup_code = 'BLANKET' and poh.approved_flag = 'Y'))
 and	pol.category_id = x_category_id
 and 	pol.item_id is not null
 and 	poh.vendor_id = x_vendor_id;

Line: 77

select	decode(x_type, 'ITEM_COUNT', count(prl.item_id)
		     , 'QUANTITY_SUM', sum(prl.quantity)
		     , 'TOTAL_AMOUNT', sum(prl.unit_price*prl.quantity))
into	x_count_or_sum
from 	po_requisition_headers prh
	, po_requisition_lines prl
where 	prh.requisition_header_id = prl.requisition_header_id
and 	nvl(prh.authorization_status, 'APPROVE') <> 'INCOMPLETE'
and 	nvl(prh.cancel_flag,'N') <> 'Y'
and 	prl.vendor_id = x_vendor_id
and	prl.category_id = x_category_id
and 	prl.item_id is not null;

Line: 105

  SELECT concatenated_segments
  INTO   x_concat_segments
  FROM   GL_CODE_COMBINATIONS_KFV
  WHERE  code_combination_id = x_cc_id;

Line: 132

select decode(upper(gl_qualifier)
		,'COST CENTER', 'FA_COST_CTR'
		,'COMPANY','GL_BALANCING'
		,'ACCOUNT','GL_ACCOUNT'
		, null)
into v_seg_name
from sys.dual;

Line: 149

	select decode(v_seg_number
		,'SEGMENT1',SEGMENT1
		,'SEGMENT2', SEGMENT2
		,'SEGMENT3', SEGMENT3
		,'SEGMENT4', SEGMENT4
		,'SEGMENT5', SEGMENT5
		,'SEGMENT6', SEGMENT6
		,'SEGMENT7', SEGMENT7
		,'SEGMENT8', SEGMENT8
		,'SEGMENT9', SEGMENT9
		,'SEGMENT10', SEGMENT10
		,'SEGMENT11', SEGMENT11
		,'SEGMENT12', SEGMENT12
		,'SEGMENT13', SEGMENT13
		,'SEGMENT14', SEGMENT14
		,'SEGMENT15', SEGMENT15
		,'SEGMENT16', SEGMENT16
		,'SEGMENT17', SEGMENT17
		,'SEGMENT18', SEGMENT18
		,'SEGMENT19', SEGMENT19
		,'SEGMENT20', SEGMENT20
		,'SEGMENT21', SEGMENT21
		,'SEGMENT22', SEGMENT22
		,'SEGMENT23', SEGMENT23
		,'SEGMENT24', SEGMENT24
		,'SEGMENT25', SEGMENT25
		,'SEGMENT26', SEGMENT26
		,'SEGMENT27', SEGMENT27
		,'SEGMENT28', SEGMENT28
		,'SEGMENT29', SEGMENT29
		,'SEGMENT30', SEGMENT30)
	into v_seg_value
	from gl_code_combinations_kfv
	where code_combination_id = cc_id
	and rownum = 1;

Line: 200

  SELECT distinct full_name
  INTO   x_person_name
  FROM   PER_ALL_PEOPLE_F
  WHERE  x_person_id = person_id;