APPS.ICX_GET_ORDER SQL Statements

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

Line: 9

select
  SEGMENT1
  into CODE_ID
  from PO_HEADERS_ALL POHEAD
  where 	PO_HEADER_ID = IN_HEAD_ID
  ;

Line: 23

select
  SEGMENT1
  into CODE_ID
  from PO_REQUISITION_HEADERS_ALL
  where 	REQUISITION_HEADER_ID = IN_HEAD_ID
  ;

Line: 37

select
  SEGMENT1
  into CODE_ID
  from MTL_SALES_ORDERS
  where 	SALES_ORDER_ID = IN_HEAD_ID
  ;

Line: 51

select
  WIP_ENTITY_NAME
  into CODE_ID
  from WIP_ENTITIES
  where 	WIP_ENTITY_ID = IN_HEAD_ID
  ;