APPS.CSD_RECEIVE_UTIL SQL Statements

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

Line: 50

         SELECT itm.receiving_routing_id,
                itm.location_control_code, itm.serial_number_control_code
           FROM mtl_system_items_b itm
          WHERE itm.inventory_item_id = p_item_id
            AND itm.organization_id = p_org_id;

Line: 61

         SELECT rcp.receiving_routing_id
           FROM rcv_parameters rcp
          WHERE organization_id = p_org_id;

Line: 71

         SELECT mip.routing_header_id
           FROM mtl_interorg_parameters mip
          WHERE from_organization_id = p_from_org
            AND to_organization_id = p_to_org;

Line: 83

         SELECT DECODE (itm.return_inspection_requirement,
                        1, g_inspection_routing,
                        null
                       ),
                itm.location_control_code, itm.serial_number_control_code
           FROM mtl_system_items_b itm
          WHERE itm.inventory_item_id = p_item_id
            AND itm.organization_id = p_org_id;

Line: 268

             EXECUTE IMMEDIATE 'SELECT nvl(RMA_RECEIPT_ROUTING_ID, '||g_standard_routing ||')'
                              || 'FROM RCV_PARAMETERS WHERE organization_id =:1'
                            --|| p_inv_org_id --4277749 TBD
                         --4277749 changed the exec to use using clause
                         INTO l_routing_header_id using p_inv_org_id;

Line: 344

         SELECT 'x'
           FROM mtl_secondary_inventories
          WHERE secondary_inventory_name = p_subinv
            AND organization_id = p_org_id;

Line: 355

         SELECT Current_status
           FROM mtl_serial_numbers
          WHERE -- current_organization_id = p_org_id
		  --AND
		  inventory_item_id = p_inventory_item_id
            AND serial_number = p_serial_number;

Line: 521

         SELECT header_interface_id
           FROM rcv_headers_interface
          WHERE GROUP_ID = p_group_id;

Line: 531

         SELECT interface_transaction_id
           FROM rcv_transactions_interface
          WHERE GROUP_ID = p_group_id;

Line: 542

         SELECT column_name, error_message
           FROM po_interface_errors
          WHERE (interface_header_id = p_hdr_intf_id OR
                 interface_line_id = p_line_intf_id) ;

Line: 549

      SELECT  oe_order_header_id,
              oe_order_line_id
      FROM  rcv_transactions_interface
      WHERE interface_transaction_id = p_interface_transaction_id;

Line: 690

         SELECT hr.employee_id
           FROM fnd_user fnd, per_employees_current_x hr
          WHERE fnd.user_id = p_user_id
            AND fnd.employee_id = hr.employee_id
            AND ROWNUM = 1;

Line: 780

     SELECT SHIP_FROM_ORG_ID
	FROM OE_ORDER_LINES_ALL
	WHERE LINE_ID = p_order_line_id;

Line: 791

         SELECT MAX (category_id)
           FROM mtl_item_categories
          WHERE inventory_item_id = p_item_id
            AND organization_id = p_org_id
            AND category_set_id = p_category_set_id;

Line: 801

         SELECT mdsv.category_set_id
           FROM mtl_default_sets_view mdsv
          WHERE mdsv.functional_area_id = 2;

Line: 811

         SELECT primary_unit_of_measure
           FROM mtl_item_flexfields
          WHERE inventory_item_id = p_item_id AND organization_id = p_org_id;

Line: 822

         SELECT lot_control_code, serial_number_control_code
           FROM mtl_system_items
          WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;

Line: 832

         SELECT unit_of_measure
           FROM mtl_units_of_measure_vl
          WHERE uom_code = p_uom_Code ;