APPS.POS_GET SQL Statements

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

Line: 19

  SELECT full_name
  INTO   x_person_name
  FROM   PER_ALL_PEOPLE_F
  WHERE  x_person_id = person_id
  AND EFFECTIVE_END_DATE >= ALL(SELECT EFFECTIVE_END_DATE
				FROM PER_ALL_PEOPLE_F
				WHERE PERSON_ID=x_person_id);

Line: 79

	select msi.concatenated_segments
	into ret_val
	from mtl_system_items_kfv msi
	where rowid = ri;

Line: 101

  SELECT concatenated_segments
  INTO   x_concat_segments
  FROM   GL_CODE_COMBINATIONS_KFV
  WHERE  code_combination_id = x_cc_id;

Line: 130

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: 147

	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: 206

	select 'T'
	into ret_val
	from mtl_system_items_kfv msi
	where msi.inventory_item_id = x_item_id
        and   msi.organization_id   = x_org_id
        and   msi.bom_item_type     = 4
        and   msi.base_item_id is not null
        and   nvl(msi.auto_created_config_flag, 'N') = 'Y';

Line: 234

	select msi.concatenated_segments
	into ret_val
	from mtl_system_items_kfv msi
	where inventory_item_id = x_item_id and
              organization_id = x_org_id;