APPS.INV_RESERVATION_WORKFLOW SQL Statements

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

Line: 41

   SELECT
     segment1, segment2, segment3, segment4, segment5,
     segment6, segment7, segment8, segment9, segment10,
     segment11, segment12, segment13, segment14, segment15,
     segment16, segment17, segment18, segment19, segment20
   INTO
     l_segs1(1), l_segs1(2), l_segs1(3), l_segs1(4), l_segs1(5),
     l_segs1(6), l_segs1(7), l_segs1(8), l_segs1(9), l_segs1(10),
     l_segs1(11), l_segs1(12), l_segs1(13), l_segs1(14), l_segs1(15),
     l_segs1(16), l_segs1(17), l_segs1(18), l_segs1(19), l_segs1(20)
   FROM mtl_system_items
   WHERE organization_id = p_organization_id
     AND inventory_item_id = p_inventory_item_id;

Line: 118

   SELECT
     segment1, segment2, segment3, segment4, segment5,
     segment6, segment7, segment8, segment9, segment10,
     segment11, segment12, segment13, segment14, segment15,
     segment16, segment17, segment18, segment19, segment20
   INTO
     l_segs1(1), l_segs1(2), l_segs1(3), l_segs1(4), l_segs1(5),
     l_segs1(6), l_segs1(7), l_segs1(8), l_segs1(9), l_segs1(10),
     l_segs1(11), l_segs1(12), l_segs1(13), l_segs1(14), l_segs1(15),
     l_segs1(16), l_segs1(17), l_segs1(18), l_segs1(19), l_segs1(20)
   FROM mtl_item_locations
   WHERE organization_id = p_organization_id
     AND inventory_location_id = p_locator_id;

Line: 460

   SELECT
       organization_id
     , inventory_item_id
     , revision
     , lot_number
     , subinventory_code
     , locator_id
     , demand_source_type_id
     , demand_source_header_id
     , demand_source_line_id
     , demand_source_name
     , supply_source_type_id
     , supply_source_header_id
     , supply_source_line_id
     , supply_source_name
     , supply_source_line_detail
     , primary_uom_code
     , primary_reservation_quantity
     INTO
       l_organization_id
     , l_inventory_item_id
     , l_revision
     , l_lot_number
     , l_subinventory_code
     , l_locator_id
     , l_demand_source_type_id
     , l_demand_source_header_id
     , l_demand_source_line_id
     , l_demand_source_name
     , l_supply_source_type_id
     , l_supply_source_header_id
     , l_supply_source_line_id
     , l_supply_source_name
     , l_supply_source_line_detail
     , l_primary_uom_code
     , l_primary_reservation_quantity
     FROM mtl_reservations
     WHERE reservation_id = p_reservation_id;

Line: 499

   SELECT organization_code
     INTO l_organization_code
     FROM mtl_parameters
     WHERE organization_id = l_organization_id;

Line: 520

   SELECT transaction_source_type_name INTO l_demand_source_type
     FROM mtl_txn_source_types
     WHERE transaction_source_type_id = l_demand_source_type_id;

Line: 524

   SELECT transaction_source_type_name INTO l_supply_source_type
     FROM mtl_txn_source_types
     WHERE transaction_source_type_id = l_supply_source_type_id;

Line: 570

PROCEDURE selector
  ( itemtype IN  VARCHAR2,
    itemkey  IN  VARCHAR2,
    actid    IN  NUMBER,
    command  IN  VARCHAR2,
    result   OUT NOCOPY VARCHAR2
    ) IS
BEGIN
      If ( command = 'RUN' ) then
         result := 'HANDLE_BROKEN_RESERVATION';

Line: 587

		      , 'SELECTOR'
		      , itemtype
		      , itemkey
		      , To_char(actid)
		      , command
		      );

Line: 594

END selector;