APPS.OE_SO_ATO SQL Statements

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

Line: 39

SELECT COUNT(1),
       SUM(DECODE(SCHEDULE_STATUS_CODE, 'RESERVED', QUANTITY, 0)),
       SUM(DECODE(SCHEDULE_STATUS_CODE, 'SUPPLY RESERVED', QUANTITY, 0)),
       SUM(Quantity)
INTO   l_number_of_config_details,
       l_reserved_quantity,
       l_supply_reserved_quantity,
       l_configured_quantity
FROM   SO_LINE_DETAILS
WHERE  LINE_ID = x_line_id
AND    CONFIGURATION_ITEM_FLAG = 'Y';

Line: 58

  SELECT DECODE(COUNT(1), 0, 0, 4)
  INTO x_s27
  FROM SO_LINE_DETAILS
  WHERE LINE_ID = x_line_id
  AND SCHEDULE_STATUS_CODE = 'DEMANDED';

Line: 79

  SELECT sales_order_id
  INTO   l_demand_source_header_id
  FROM   mtl_sales_orders mso
  WHERE  segment1 = To_Char(x_order_number)
  AND    segment2 = x_order_type
  AND    segment3 = FND_PROFILE.Value_Specific('SO_SOURCE_CODE');

Line: 99

  SELECT INVENTORY_ITEM_ID, MIN(LINE_DETAIL_ID)
  INTO   x_configuration_item_id, x_config_line_detail_id
  FROM   SO_LINE_DETAILS S
  WHERE  S.LINE_ID = x_line_id
  AND  CONFIGURATION_ITEM_FLAG = 'Y'
  GROUP BY INVENTORY_ITEM_ID;

Line: 106

  SELECT DESCRIPTION
  INTO  x_config_item_description
  FROM   MTL_SYSTEM_ITEMS M
  WHERE  M.INVENTORY_ITEM_ID = x_configuration_item_id
  AND    M.ORGANIZATION_ID = NVL(x_warehouse_id, x_organization_id);

Line: 119

SELECT DEMAND_SOURCE_DELIVERY, USER_DELIVERY
INTO   x_demand_source_delivery,
       x_user_delivery
FROM   MTL_DEMAND
WHERE  INVENTORY_ITEM_ID = x_inventory_item_id
AND    DEMAND_SOURCE_TYPE = 2
AND    DEMAND_SOURCE_HEADER_ID = l_demand_source_header_id
AND    DEMAND_SOURCE_LINE = x_line_id
AND    ORGANIZATION_ID = NVL(x_warehouse_id, x_organization_id)
AND    ROWNUM = 1;

Line: 132

  SELECT sum(wip_completed_quantity)
  into x_reserved_quantity
  from so_line_details
  where line_id = x_line_id
  and   inventory_item_id = x_configuration_item_id;

Line: 144

SELECT TO_CHAR(CREATION_DATE,'YYYY/MM/DD HH24:MI')
INTO x_creation_date_time
FROM SO_LINES
WHERE LINE_ID = x_line_id;

Line: 150

SELECT 	a.name, r.name, to_char(l.s27_date, 'YYYY/MM/DD HH24:MI')
INTO	x_mfg_action, x_mfg_result, x_action_date
FROM	SO_ACTIONS A,
	SO_RESULTS R,
	SO_LINES   L
WHERE
	L.LINE_ID	= x_line_id
AND	A.RESULT_TABLE  = 'SO_LINES'
AND	R.RESULT_ID     = L.S27
AND	A.RESULT_COLUMN = 'S27';