APPS.POS_GET SQL Statements

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

Line: 18

  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_PEOPLE_F
				WHERE PERSON_ID=x_person_id);

Line: 78

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

Line: 100

  SELECT concatenated_segments
  INTO   x_concat_segments
  FROM   GL_CODE_COMBINATIONS_KFV
  WHERE  code_combination_id = x_cc_id;

Line: 129

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

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

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

	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;