APPS.OE_SERVICES_PROCESS SQL Statements

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

Line: 18

	SELECT DECODE(msi.service_item_flag,'Y', 'SERVICE', 'UNKNOWN' )
	,     TO_CHAR(  SERVICES_INVENTORY_ITEM_ID )
	,     DESCRIPTION
	FROM   MTL_SYSTEM_ITEMS msi
	WHERE  msi.ORGANIZATION_ID   = X_ORG_ID
	AND    msi.INVENTORY_ITEM_ID = X_SERVICES_INVENTORY_ITEM_ID;

Line: 35

	/*SELECT TO_CHAR(  SERVICES_INVENTORY_ITEM_ID )
	,     DESCRIPTION
       	INTO   SERVICES_COMPONENT_CODE
	,      SERVICES_ITEM_DESCRIPTION
	FROM   MTL_SYSTEM_ITEMS
	WHERE  ORGANIZATION_ID   = ORGANIZATION_ID
	AND    INVENTORY_ITEM_ID = SERVICES_INVENTORY_ITEM_ID;*/

Line: 111

      SELECT Nvl(Max(line_number), 0) + 1
      FROM   so_lines
      WHERE  service_parent_line_id = X_Service_Parent_Line_Id ;