APPS.INV_CACHE SQL Statements

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

Line: 17

      SELECT *
	INTO org_rec
	FROM MTL_PARAMETERS
	WHERE organization_id = p_organization_id;

Line: 42

      SELECT *
	INTO org_rec
	FROM MTL_PARAMETERS
	WHERE organization_code = p_organization_code;

Line: 69

      SELECT *
	INTO item_rec
	FROM MTL_SYSTEM_ITEMS
	WHERE organization_id = p_organization_id
	AND inventory_item_id = p_item_id;

Line: 97

      SELECT *
	INTO tosub_rec
	FROM MTL_SECONDARY_INVENTORIES
	WHERE organization_id = p_organization_id
	AND secondary_inventory_name = p_subinventory_code;

Line: 125

      SELECT *
	INTO fromsub_rec
	FROM MTL_SECONDARY_INVENTORIES
	WHERE organization_id = p_organization_id
	AND secondary_inventory_name = p_subinventory_code;

Line: 150

      SELECT *
	INTO mmtt_rec
	FROM MTL_MATERIAL_TRANSACTIONS_TEMP
	WHERE transaction_temp_id = p_transaction_temp_id;

Line: 174

      SELECT *
	INTO mol_rec
	FROM MTL_TXN_REQUEST_LINES
	WHERE line_id = p_line_id;

Line: 198

      SELECT *
	INTO mtrh_rec
	FROM MTL_TXN_REQUEST_HEADERS
	WHERE header_id = p_header_id;

Line: 222

      SELECT *
	INTO wdd_rec
	FROM WSH_DELIVERY_DETAILS
	WHERE move_order_line_id = p_move_order_line_id;

Line: 257

      SELECT *
	INTO mso_rec
	FROM mtl_sales_orders
	WHERE segment1 = l_order_number
	AND segment2 = l_order_type
	AND segment3 = l_order_source ;

Line: 298

      SELECT *
	INTO  mso_rec
	FROM mtl_sales_orders
	WHERE sales_order_id = p_salesorder_id ;

Line: 329

      SELECT *
	INTO mtt_rec
	FROM MTL_TRANSACTION_TYPES
	WHERE transaction_type_id = p_transaction_type_id;

Line: 421

      SELECT *
	INTO oola_rec
	FROM oe_order_lines_all
	WHERE line_id = p_order_line_id;

Line: 455

      SELECT *
	INTO wpb_rec
	FROM wsh_picking_batches
	WHERE batch_id = p_batch_id;

Line: 462

      SELECT *
	INTO wpb_rec
	FROM wsh_picking_batches
	WHERE name = p_request_number;

Line: 491

       SELECT *
       INTO loc_rec
       FROM MTL_ITEM_LOCATIONS
       WHERE inventory_location_id = p_locator_id
       AND organization_id = p_organization_id;

Line: 533

      SELECT status_id
      INTO moqd_rec.status_id
      FROM MTL_ONHAND_QUANTITIES_DETAIL
      WHERE inventory_item_id = p_inventory_item_id
      AND organization_id = p_organization_id
      AND subinventory_code = p_sub_code
      AND nvl( locator_id, -9999) =nvl(p_loc_id, -9999)
      AND nvl(lot_number, '@@@@') = nvl(p_lot_number, '@@@@')
      AND nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999)
      AND rownum  = 1;

Line: 568

      SELECT allow_cross_proj_issues
           , allow_cross_unitnum_issues
           INTO pjm_org_parms_rec.allow_cross_proj_issues,
           pjm_org_parms_rec.allow_cross_unitnum_issues
        FROM pjm_org_parameters
       WHERE organization_id = p_organization_id;

Line: 613

      IS SELECT * FROM MTL_CLIENT_PARAMETERS
      WHERE client_id = p_client_id ;

Line: 684

                SELECT 2 INTO x_serial_tag
                FROM DUAL
                WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments
                              WHERE organization_id = p_organization_id
                              AND inventory_item_id = p_inventory_item_id
                              AND transaction_type_id = l_txn_type
                            );